2nd Combo box does not change subform

[Ryan]

I have 2 combo boxes on a form with the relevant information being displayed
in the subform. The selection in the 1st combo box restricts the value in the
2nd combo box and also restricts the data in the subform. Perfect.

My problems arise when I select a value in the 2nd combo box. It does
nothing to my subform. It does not restrict the data in the subform, (My
subform is based on the same table as my form - if this makes a difference?)
Any help is greatly appreciated to get the second combo box to filter
properly.

 

[Wolfgang Kais]

Hello "Ryan".

I have 2 combo boxes on a form with the relevant information being
displayed in the subform. The selection in the 1st combo box
restricts the value in the 2nd combo box and also restricts the data
in the subform. Perfect.

My problems arise when I select a value in the 2nd combo box. It
does nothing to my subform. It does not restrict the data in the
subform, (My subform is based on the same table as my form - if this
makes a difference?) Any help is greatly appreciated to get the
second combo box to filter properly.

You did not tell us how the filter is meant to be applied to the
subform. Are you using the filter property of the subform in the
AfterUpdate event procedure (of combo 1) or the LinkChildFields and
LinkMasterFields properties of the subform control?

 

[Ryan]

Hi Wolfgang
I am using the LinkChildFields and LinkMasterFields properties of the
subform control.

 

[Wolfgang Kais]

Hello Ryan.

I am using the LinkChildFields and LinkMasterFields properties of
the subform control.

First: As I understand it, teh main form schould mot be bound to a
table at all.
Second: Use both properties of the subform control for both combos:
LinkChildFields: FieldRelatedToComboBox1;FieldRelatedToComboBox2
LinkMasterFields: ComboBox1.Value;ComboBox2.Value

 

[Wolfgang Kais]

Sorry Ryan.

I wrote:
LinkMasterFields: ComboBox1.Value;ComboBox2.Value
This should be:
LinkMasterFields: ComboBox1;ComboBox2
(wipe out .Value)