Joe8915
Registered User.
- Local time
- Yesterday, 23:34
- Joined
- Sep 9, 2002
- Messages
- 820
I have a field called Invoice Number. If the Invoice Number contains the word final, then display a MsgBox "do something"
this is what I have so far.
Private Sub Invoice_Number_AfterUpdate()
IIf = (Invoice_Number) <> "final"
MsgBox ("then do something")
End Sub
Of course I get a error. Where did I go wrong?
this is what I have so far.
Private Sub Invoice_Number_AfterUpdate()
IIf = (Invoice_Number) <> "final"
MsgBox ("then do something")
End Sub
Of course I get a error. Where did I go wrong?