Filter on a form

  • Thread starter Thread starter Omar
  • Start date Start date
O

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.

Thanks for the help
 
Omar said:
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.
Click to expand...

You need the same macro in the Current event of the main form. That event fires
every time you change records.
 
Back
Top