How do I require a user to enter data in a form before moving on?

  • Thread starter Thread starter kbright
  • Start date Start date
K

kbright

I need to require a user to populate a form with basic info when we create
new accts in our database. How do I require the user to populate the field
before moving on to the next field? I'm using Access 03
 
I need to require a user to populate a form with basic info when we create
new accts in our database. How do I require the user to populate the field
before moving on to the next field? I'm using Access 03
Click to expand...

As a general (not absolute and universal) rule, the Windows user interface
assumes that you can enter data in any order you wish on a screen. Is it
*essential* to the functioning of your database that the fields must be
entered in a specific sequential order? If so, why?

Normally one would either have the required fields specified as Required in
table design view, and/or use code in the form's BeforeUpdate event to check
for blank fields and cancel the addition if something essential is left out.
Perhaps you could post a bit more detail about your needs and the structure of
your database and someone could suggest a more specific solution.
 
Back
Top