On <condition met> do nothing else do this... how do I do this?

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..
 
D

Dennis

This seems too simple, I suspect there is more to it than this

If Me.OrderTotal > Me.CreditLimit And Status <> "Proforma" Then
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top