How to warn users to input data in certain fields

[Guest]

Hello everyone.

I have a table. Within this table I have 3 fields in which the required
field property is set to "yes". The data in this table is run through a
query and eventually a form. The form is where the end user will be entering
in his/her data. How do I create a pop up message stating that he/she has to
fill in these fields? I noticed that the records aren't saved if these
fields aren't filled in, and there aren't any existing warning messages that
pop up. I'm not sure how to go about this. If you could help, I would
appreciate it.

Casa

 

[Ken Snell [MVP]]

Normally the BeforeUpdate event of the the control or the form is used to
validate that an entry has been made into a control. Which one you use
depends upon how you want to let the user move around the form (using the
control's event requires the user to enter something before he/she can move
to the next control, and using the form's event requires the user to enter
something before the record can be saved).

I'm surprised that you don't get an error message in your situation, unless
you also have "Allow Zero Length" property set to Yes for those fields.