form field

F

form field

Hi, I made a form, now how can I set a form like user have to fill field, or
the form will not go forward.

Thank you
 
O

Ofer Cohen

You can use the before update event of the form to check if the fields are
filled, if not prompt a message and stop from going forward

Something like

If IsNull(Me.[TextBox1Name]) Or IsNull(Me.[TextBox2Name]) Then
MsgBox "Fields must be filled"
Cancel = True ' Wont let the user to continue until the fields are filled
End If
 
Top