I have a form with 10 fields. All of them are mandatory (Required = yes).
I want the user to enter the fields sequentially. I would not like them to skip a field to enter another.
How can I do this?
I have a form with 10 fields. All of them are mandatory (Required = yes).
I want the user to enter the fields sequentially. I would not like them to skip a field to enter another.
How can I do this?
Assuming that you have a valid business reason for wanting to do this (end users really, really hate being told how to fill a Form in!)...In the Form_Current event:
- Disable all Controls except the first one to be populated
- In the AfterUpdate event of the first Control, if it isn't Null (empty), Enable the second Control
- And so forth...for each Control, in turn
Linq Adams ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Hmm... I agree with you... Even I felt irked while filling up the form!
Dropping this idea!
Thanks for the solution as well!