tab control

[Omar]

Thanks for taking the time to read my question.

I have a form that includes numberous subforms using the
tab control tool box. I have a macro setup under a combo
box field within the main form to point to a specify tab
under the tab control.This allows an individuals to choose
a particular subject under the main menu and have that
subject's subform be viewed. This macro runs under the
afterupdate option.

The problem that Im having is that when I search thru the
entries within the main form, the combo box changes
occurringly depending on the subform that was filled but
the macro no longer changes the corresponding tab within
the tab control. I tried to run the macro under the
OnChange option, but this this not work either.

 

[Allen Browne]

You need to use an unbound combo.

Open the form in design view.
Right-click the combo, and choose Properties.
On the Data tab of the Properties box, remove the entry beside:
Control Source.

The combo is no longer bound to a field of the record, so it is free to be
used for navigation only.