4 cascading combo boxes

[bodvoc]

Hi guys

I have searched and searched on this one, but still in the dark.

I have a form, with 4 combo boxes. 1) ActivityType, 2) Actvivity, 3) Statement, 4) Value.

What I need to do is when combo1 has a value selected, it limits the list in combo2, and so on.

The tables behaind are set up like:

Combo1
IDActType
value

Combo2
IDActType
IDAct
Value

Combo3
IDActType
IDAct
IDState
Value

Combo4
IDActType
IDAct
IDState
IDValue
Value

I am using code that works, but I must be doing it in a very long hand way, Textboxes holding the ID of the combo before and requery on click the next combo to limit the list shown. I have inhereited the db and data here, and changing it would cause loads of problems with historical records. I don't want to end up with hundreds of tables either ;o(

Any ideas greatly welcome.

Cheers Bodvoc

 

[Hayley Baxter]

Here's an example which uses 4 cascading combo boxes that might help you.

 

[bodvoc]

Thanks

Cheers for that, looks just what I wanted, just go to get the data to fit it.

Do you know if it can also be used to look up exsisting records to modifie them?

Bodvoc