requiring form controls to have non-empty values for new records

[Paul James]

What is the simplest way to require that two form controls have non-empty
values for new records? I can't do this in the table, because the data is
being entered in phases, and during the initial phases, those fields will be
blank. However, there is a point when I need to require that values be
entered in these fields.

Can I do this at both form and query level? If so, please tell me how to do
it. I tried entering "Not Is Null" in the Validation Rule property of the
form control, but that didn't prevent me from creating new records with
empty values in those fields.

Thanks in advance.

Paul