Combo Box Requery

[Ann]

I'm having a hard time with my replies posting so I am going to submit a new
question. I apologize it's a repeat.

I made the change to the row source for the combo box and will see the
correct data the first time I click the dropdown. I would expect this
because I haven't done the second and third part yet. Since I posted I've
had to add the subform to a Control Tab and I'm having a hard time with the
following: Me.subformcontrol.Form.thecombobox.Requery.

I have a main form called frmVendors, a Combo Box on it called
cboVendorSearch, a Tab Control called TabCtl9 with a Page called Courses
(it's Page Index is 1), a subform called frmCourses on the Tab Control, and a
Combo Box on the subform called cmbCourseSearch.

When the cboVendorSearch changes it should only show the Courses in the
cboCourseSearch for that one vendor. I'm confused on how to get
Me.subformcontrol.Form.thecombobox.Requery to work now that I have a Tab
Control.

I've tried many different ways to write this and place it on the On Current
of the main form and the cboVendorSearch AfterUpdate. Can anyone tell me how
to do this.

Also, is there information anywhere stating how to reference other controls
on other subforms and also those that are on Tab Controls? I see so many
different ways of referencing I'm very confused.

 

[SteveD]

One way .... for the combobox, add an OnEnter ... me.comboboxName.requery

SteveD