R
Richard Horne
I have a check on a form that prompts the user with an error message if a
field called OrderTotal is higher than the customer's credit limit, called
CreditLimit.
However I don't want this check to apply if their status is proforma, how do
I do this?
My current code is:
Private Sub Order_Entry_Complete_Click()
If Me.OrderTotal > Me.CreditLimit Then
MsgBox "This order is for a higher value than this customer's credit limit!
Check with Robin and Karen before proceeding!"
Order_Entry_Complete = False
Exit Sub
End If
Me.Requery
End Sub
I want basically the same as above but:
If Terms = "Proforma"
Then do nothing, else ... etc etc..
field called OrderTotal is higher than the customer's credit limit, called
CreditLimit.
However I don't want this check to apply if their status is proforma, how do
I do this?
My current code is:
Private Sub Order_Entry_Complete_Click()
If Me.OrderTotal > Me.CreditLimit Then
MsgBox "This order is for a higher value than this customer's credit limit!
Check with Robin and Karen before proceeding!"
Order_Entry_Complete = False
Exit Sub
End If
Me.Requery
End Sub
I want basically the same as above but:
If Terms = "Proforma"
Then do nothing, else ... etc etc..