disable add record button if any field

[Abdullah Tariqu]

hi to all,
if any field of data entry user skipped and click to add record button then i want to show a message to complete data entry and not added record in table. so pls help us.
Thanks on advance.
Abdullah Tarique

[Seth Schrock]

I hope you don't have very many fields. You are going to have to test the value in each control that is bound to a field to make sure that it isn't empty.

If (Me.Control1 & "" <> "") And (Me.Control2 & "" <> "") Then
    'Code to add the record
Else
    MsgBox "Please complete the entry form."
End If