Main Form Mandatory fields patti 12/24/2008 12:25:01 AM 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.

Re: Main Form Mandatory fields Marshall Barton <marshbarton[ at ]wowway.com> 12/24/2008 12:43:18 AM patti wrote: [Quoted Text] >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. 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. -- Marsh MVP [MS Access]