Main Form Mandatory fields

P

patti

I have a form with 3 tabs. The first tab is the main form. I do not want
fields field on the 2nd tab filled in unless all the mandatory fields are
filled in on the main form. What is the best way to accomplish this? Then,
the third tab should not be filled in until the necessary fields are filled
in on the 2nd tabbed form.

Thanks for the help.
 
M

Marshall Barton

patti said:
I have a form with 3 tabs. The first tab is the main form. I do not want
fields field on the 2nd tab filled in unless all the mandatory fields are
filled in on the main form. What is the best way to accomplish this? Then,
the third tab should not be filled in until the necessary fields are filled
in on the 2nd tabbed form.
Click to expand...


You can disable the 2nd tab. The AfterUpdate event of the
critical controls can check if they are all filled in, If
they are, enable the tab page.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Check mandatory fields using VBA not working properly 12
Checking a forms fields for null 1
Template with fields and premade texts.. 0
Request Form - Alert Team Member 0
Is this possible? 0
Populate main form from subform record 0
Main form with subforms 3

Top