Validating form

[Daniel]

What is the easiest way to make sure that all the fields
in a form are filled in to avoid the Access system message
that something is not filled in upon close? Is there
something you can put on the Close event to verify that
all is filled out? Do I have to IsNull(Field) on all the
fields in question?

Thanks

Dan

 

[Allen Browne]

If you do not want to save the record while fields are null, use the form's
BeforeUpdate event to run the test.

A simpler solution is to open the table in design view and set the Required
property (lower pane) to Yes for the appropriate fields.