I use the following code in my save button for an instance when a user fails to populate a field so they will go back and fill in the field:
If (IsNull(Company)) Then
MsgBox "Please Choose a Company Name", vbExclamation
Cancel = True
this works fine for one field however when i do the following it still only checks the first one, can someone tell me the proper way to write this so that I can get more than one field to be recognized:
If (IsNull(Company)) Then
MsgBox "Please Choose a Company Name", vbExclamation
Cancel = True
If (IsNull(Quantity)) Then
MsgBox "Please Enter the Quantity", vbExclamation
Cancel = True
End If
thank you!!!
Paul
If (IsNull(Company)) Then
MsgBox "Please Choose a Company Name", vbExclamation
Cancel = True
this works fine for one field however when i do the following it still only checks the first one, can someone tell me the proper way to write this so that I can get more than one field to be recognized:
If (IsNull(Company)) Then
MsgBox "Please Choose a Company Name", vbExclamation
Cancel = True
If (IsNull(Quantity)) Then
MsgBox "Please Enter the Quantity", vbExclamation
Cancel = True
End If
thank you!!!
Paul