Dynamic combo boxes

[mmcginley]

I have a couple of combo boxes linked simply.

One is called brand and the other sub brand, and when i select a particular brand only the relevant sub brands are displayed. The problem i have is that when i reselect a different brand the sub brand combo box does not update.

I have created this setup by making the sub brand combo box a query.

The Query is:

SELECT SubBrand
FROM SubBrand.SubBrand
WHERE SubBrand.Brand=[Combo3]

Any help appreciated

Thanks in advance

 

[neileg]

You need to requery you subbrand with some code in the after update event of [combo3]

 

[btappan]

I too am interested in doing this, My brands are not in their own table but rather just set up in the value list on the properties tab. How could I implement this? I'm not too worried about the secondary box updating if the first 1 is changed.

 

[boblarson]

The second combo box MUST be set up using a query on a table (can't be a value list) or it won't be able to be a cascading list as the restricting piece of this is that it involves a query that can be limited, in the criteria, by the value selected in the first.

 

[btappan]

So would the table have brand in column 1 and then the sub brands in 2, 3, 4 etc. as nessescary?

 

[boblarson]

No, you should have a brand table and then a subbrands table (in order to stay normalized) and be usable in the query.