Combo Box Synchronization

[Guest]

I have two combo boxes in a subform with the combo box list of the second box
dependent on the selection of the first. It works great when I test it in
the sub form. However, when I open the main form, the second box shows only
a null value.

 

[Guest]

How did you filter the second combo, if you have reference to the first combo
as
Select * From TableName Where FieldName = Forms![SubFormName]![FieldName]

Then the path will change when the sub is open with the main form
Select * From TableName Where FieldName =
Forms![MainFormName]![SubFormName].Form![FieldName]