wizcow
Registered User.
- Local time
- Today, 10:37
- Joined
- Sep 22, 2001
- Messages
- 236
Hi
On my 'Invoice' form I have a subform with the line items.
The user must select each line item from a combo box called 'StoreNo'
If the user selects a 'StoreNo' that has already been used in the Invoice, they get an Access error.
I would like to supply my own MsgBox message.
I think it would be something like;
If StoreNo = StoreNo Then
MsgBox ("Duplicate Entry" & vbCrLf & "Error 321" & vbCrLf & vbCrLf & "You Must Make A Different Selection."), 48, "Error"
End If
Of course this doesn't work.
Help
Tom
On my 'Invoice' form I have a subform with the line items.
The user must select each line item from a combo box called 'StoreNo'
If the user selects a 'StoreNo' that has already been used in the Invoice, they get an Access error.
I would like to supply my own MsgBox message.
I think it would be something like;
If StoreNo = StoreNo Then
MsgBox ("Duplicate Entry" & vbCrLf & "Error 321" & vbCrLf & vbCrLf & "You Must Make A Different Selection."), 48, "Error"
End If
Of course this doesn't work.
Help
Tom
