Linking Combo Boxes

[Adam]

I posted here last week, and tried everyones help along with searching the
forums, but have yet to figure it out.

I have a table (MODU) with 13 columns, each a different characteristic of
offshore drilling rigs. Im trying to create a form that has 13 combo boxes,
one for each table column. I need to be able to choose any combo box, select
something, and the other 12 combos use what was chosen to filter whats in
them. Then be able to choose another random combo box, choose something, the
rest filter, and so forth through all 13 combo boxes.

I would post the codes i have thus far, but i have about 3 different
approaches, each from someone differents take on the situation.

Any help is appreciated.

 

[Arvin Meyer [MVP]]

I have an example of doing that here:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Adam]

Sorry to be so Access illiterate, but i opened your Combo file, and clicked
your frmProducts form, and then filter by form. How do you use this from
after that? I see you can choose anything from all the combo boxes, but dont
see how to filter and give a final product that matches everything.

 

[Arvin Meyer [MVP]]

Open the form, click on any value in the first list box, that will fill the
second list box. Click on a value in the second list box and it will
navigate to the record.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Adam]

Appreciate the database, but its not quite what im trying to do.