Required info

[brbarto]

I have a combo box (LastName) on a subform (driver infomation). (The main form is the vehicle rental request.) The user picks a last name (or types it in). The SSN is what is stored.
How do I make it required that the user must enter at least one driver?

Thanks

 

[JoaoTL]

Use this OnAfterUpdate() Event of LastName

If IsNull(Me.LastName) Then
MsgBox"THI FIELD IS REQUIRED",VbInformation,"Error"
Else
'Do Nothing
End If Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt