Cascading combo box lists

[pete61uk]

For me, a complex Access 2000 problem, that of cascading combo box lists:

I've seen a good example, but in that instance each subsequent lists' records are taken from their own unique table with no sorting required.

In my scenario all of the records (for Service and Service Detail) are held within their own table, and the list needs to be restricted to only those relevant to the previous selection.

Further complicating the issue(?), there are 3 combo boxes, 1 on the Main Form [Market] and 2 on a subForm, [Service] and [Service Detail].

Any suggestions welcome

[opel]

Can you expand a little on this please...

You have a combo box on main form and you want to use this value to show relevant data on other forms ?

on the main form, called say FORMA using the combo box field as say combo0.

to use the selected item on another form, use the data criteria as

forms!formsa!combo0