Yes/No Message Box

[Eddie1976]

I am trying to multiply a value by a decimal depending on whether the person choses yes or no. Below is the code I am currently using. Any help is greatly appreciated.

If Me.CreditorIDB.Value = 758 Then
msg = "Is this account over the credit limit?"
If MsgBox(msg, vbYesNo, "Over Limit&quot = vbYes Then
Me.OurPayment.Value = Me.Balance.Value * 0.03
Else
Me.OurPayment.Value = Me.Balance.Value * 0.02
End if

Thanks.
Ed

 

[zishan619]

You can:
dim msg as string
msg = MsgBox"Is this account over the credit limit?"
If Me.CreditorIDB.Value = 758 Then
msg
elseif msg = 6 then
Me.OurPayment.Value = Me.Balance.Value * 0.03
Else
Me.OurPayment.Value = Me.Balance.Value * 0.02
End if
I think this would work. I had a similar problem. It worked out.
Thanks
Zishan