[Butterfly807]

Lol! I was just going to tell you that I figured it out by going off what you already told me. You already gave me the answer.

You've been so helpful! Just want to say..

[Butterfly807]

Is it possible to link multiple subforms in a mainform? For example, what I would like to do is have a Product/Service Search Form. It would work this way:
1. User would select a product/service category such as "Gasket"
2. User would then select the type of gasket such as "Garlock"
3. User then receives list of suppliers that provide Garlock Gasket

I'm having difficulty setting it up where I select Gasket, and then in a second combo box appears only the type of gaskets, to then produce a result of suppliers.

Does this make sense?

[OBP]

The simplest way is to Filter the second Combo based on the selection of the first combo, this is achieved using the second combo box's SQL (query) Row Source.
You use the the Criteria
Forms![Formname]![firstcomboname]

[Butterfly807]

I've set it up the way you've described, but my second combo box is coming up blank.

[OBP]

The second part is to use VBA in the first Combo's After Update event procedure to requery the second combo with
me.secondcomboname.requery

[Butterfly807]

I'm not understanding...

[OBP]

Do you know how to open the Combo's After Update Event Procedure?

[Butterfly807]

I know how to open a combo to edit after I've created them. I'm not sure what you mean by 'After Update Event Procedure' though.

[OBP]

OK, in the Properties go to the Event Tab and the After Update event is the 3rd one down. Click on it and select "Event Procedure" and then click on the 3 small dot builder on the right, it will take you to the VBA Editor at the correct event.

[Butterfly807]

Ok, I've found that. I'm not sure what I do once in the After Update. If I select Requery, I don't know how to proceed. Sorry for all the questions.

[Butterfly807]

.. And is there a way to prevent duplicates? For example, in my first combo, 'gasket' is listed about 10 times because there are 10 different possible gaskets. I want it to only be listed once.

[OBP]

You should add Grouping to the first combo SQL (Query).

Once you are in the after update event you can type in

me.

the VBA editor will now list the controls available, go down the list and find your second combo and select it then type another

.r

and it will list what you can do with the combo starting with an r, go down the list and select requery.
Then click save.

[Butterfly807]

I know I'm going to drive you crazy today. How do I add Grouping?

[OBP]

If the Ribbon is the same as 2007 you use the "Totals" at the right hand end when in design view.

[Butterfly807]

I am in 2010. I do not see anything that says "totals"