Tab control

G

Glynn

I need the user to enter data in each field - in order. Can I prevent the
user tabbing onto another field if a mandatiory field is left Null ?
 
A

Al Campagna

Glynn,
Use the OnExit event of the field, which has a Cancel capability...

If IsNull(YourFieldName) Then
Beep
MsgBox "Requires an Entry"
Cancel = True
End If

Also, make sure the field is designated "Required" in your table design, so users can't
leave the record without an entry even if they didn't tab into the field.
 
Top