Cascading Combo Boxes problem

[tom24]

Hi,
New member here, so hope I'm posting this in the correct place.
My problem is this:

I have a table "ChassisDetails" which has 7 columns as follows:
Chassis Make (e.g. DAF; ERF; MAN; Mercedes Etc..)
Tonne (e.g. 7.5; 14; 18...)
Chassis Model (e.g. LF45; Midlum...)
Axle Config (e.g. 4x2; 4x4...)
CAB (e.g. Day; Sleeper)
W/Base (e.g. 2850; 3150)
Suspension (e.g. Air; Steel)

I need to be able to refine the choice of truck by using cascading combo boxes (7) to restrict the choice selected by the next combo box, dependent upon the choice made in the previous box.

I have been able to get this to work for the first 3 (Make; Tonne; and Model) but thereafter....nothing.

Firstly, is there a restriction on the max. number of cascading combo boxes in Access? I suspect there may be, as I have not seen any postings where more than two levels are being discussed. If there is, I will need to find another way around it.

Will post more details when I know whether it is possible to do what I want.

Thanks

 

[Dennisk]

what code are you using and where are you placing it?

 

[tom24]

Hi,
Since posting my query, I seem to have resolved the problem, using the query builder to insert the output of the previous combo box into the RowSource property of the next one
e.g. for Chassis Model combo box, the query criteria reads:

Chassis Make = [Form]![Chassis Make]
Tonne = [Form]![Tonne]

and so on, each time adding the result of the last combo box to the query for the next one.
Also used the AfterUpdate property to Null and ReQuery the next combo box.

This seems to work OK for all 7 levels of combo box, but thank you anyway for your interest.

As you can probably guess, I am a fairly new Access user, so apologies if this response is maybe not detailed enough. Having now found this forum, I can see me making many more visits!

Thanks again