Moving Between Tab Controls

[bfont]

I have a form with 2 tab controls on it. I want the user to be able to fill out a portion of tab 1, then switch to tab 2, then back to tab 1 to complete the remaining fields. My issue is that I have some required controls on tab 1 so that when the user moves to tab 2, an error message is displayed saying that there are required controls on tab 1 that are blank. Is there a way to move between tabs without Access checking for blank required controls when moving between tab controls? I have added error checking on the form before update event but it still checks for blank required controls when changing tab controls.

[June7]

You have two tab controls or one tab control with two tab pages?

These are forms on tabs? If fields are set as required in table, then leaving form will commit record and if fields are not filled in, cause error. No way around that expect to not set this in table. Also triggers BeforeUpdate event. Don't think I've ever needed to use form BeforeUpdate event.

[Micron]

What events are you using? Form BeforeUpdate should not fire until an attempt to leave the record is executed, and moving between tab controls on the same form does not fire that event. Maybe one tab is on one form and the other is on a subform? That would be different.

[June7]

I agree, if no subforms are involved, should not be any issue but since there is an issue, must be moving from main form or subform to a(nother) subform.

[bfont]

Oh, yes I guess I do have 1 tab control with 2 tab pages and the form on tab 2 is a subform. I didn't set the fields as required in the table, but evidently as Micron pointed out, I am moving from the Main form to a subform. Guess I'll have to try something different. Thank you both for your help, much appreciated.

[Micron]

The whole idea of putting forms in tab control pages is so you don't have to use a subform control so why have a subform control on a page? If you mean this 'subform' is just a form that you put on a page and you use it as a subform somewhere else, then when on the page it's not a subform. If it is a form in a subform control on a page, then you should be able to delete the sf control and just put the form on the page, I would think.

And yes, when you move from one form to the other, you are causing the 1st bound form to update.

[June7]

@Micron, I am not sure what you are trying to convey. A form placed on a tab control page HAS to be within a subform container control. It's no different than placing subform directly on main form.

The idea of putting forms on tab control is to conserve screen space, not to eliminate subform container control.

[Micron]

The idea of putting forms on tab control is to conserve screen space, not to eliminate subform container control.

I know that - didn't say otherwise.
Guess I forgot the rest; been a while since I put forms on pages as apposed to controls on pages.