Synchronizing a combo box with two subforms

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?
 
K

Kelvin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

synchronized Combo Boxes in subforms 2
Synchronize combo boxes 2
Synchronization problems while moving folders to new email 1
Combo or list box 0
Weekly Report 2
Combo box 0
First Subform record gets modified when closing form 3
Linking two Subforms & showing name in place of ID? 1

Top