Synchronizing a combo box with two subforms

  • Thread starter Thread starter Jana
  • Start date Start date
J

Jana

I'd like to synchronize a combo box and two subforms in a
way that I can see the result as soon as I select the item
from the combo box in my two subforms without changing any
data in my tables/queries.

Can anyone help me out?
 
Create an unbound combo box on your main form. Then for both queries for
the 2 subforms add a criteria to the corresponding field that matches the
combo box data to Forms!NameOfMainForm!NameOfComboBox. Then in the
afterupdate event of the combo box add

Forms!NameOfMainForm!NameOfSubForm1.Form.Requery
Forms!NameOfMainForm!NameOfSubForm2.Form.Reqeury

Kelvin
 
Back
Top