Data Validation To Prevent No Entry

S

Sam Wardill

I have a form which i used to collect data used by an update query. When I
click a button on the form I trigger a macro that opens the query. The form
passes parameters to the query. When the button is pressed I want to validate
that an entry has been made in a specific text box. I have tried various
things to trigger the validation rule but none seem to work. The validation
rule only seems to trigger if you make an entry in the text box. How do I
trigger the validation rule?
 
S

Sam Wardill

Thanks for the tip. I got it working. However I had to use IsNull(Me.Field)
rather than Me.Field = ""
 
Top