Problems with Drop Down Populating with current data

[John]

I have two subforms within a main form. The combo box on
one subform has a where clause referencing a combo box on
another subform. When the combo box changes values, the
combo box that references the other combo box still shows
the information from the old value rather than the new
value that was chosen. On the After update function of
the combobox, I requery both forms, but that does not seem
to help. What do I have to do in order to get the combo
box to populate with the current information from the
other combo box?

Thanks in advance,
John

 

[Reggie]

John, Have you tried requerying the combobox?

Forms!myMainForm!mysSubForm.Form!myComb.Requery