2nd Combo box does not change subform


R

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.
 
Ad

Advertisements

W

Wolfgang Kais

Hello "Ryan".

Ryan said:
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?
 
R

Ryan

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

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
 
Ad

Advertisements

W

Wolfgang Kais

Sorry Ryan.

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

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

Top