Linking problem

[Steven811]

Hi

I've spent hours on this problem and can't resolve it and would appreciate some assistance.

I have 2 cascading combo boxes on the parent form that work okay. I wish to link the subform to the 2nd combo and have tried to do it like this:

Using the subform properties I enter the 2nd combo name in the link master field and in the link child field I enter the ID field for the subform. This same ID field is present in the 2nd combo as one of the 3 columns/fields that provide the data, although the ID field is hidden as I only see the CompanyName field in the combo.

Thanks in advance.

Steven811

 

[llkhoutx]

On the combobox2 AfterUpdate event or when combobox2 is otherwise updated, requery the the subform.