Combo Boxes in Subform

[stampr18]

I asked this question before and need more help.

I have a form (orders) and a subform (order details). In the Order Details Form I have combo boxes for Manufacturer, Product, etc. The combo boxes work as I want them in the Order Details Form. All of my combo boxes depend on what was selected from the previous combo box. When I add the Order Details Form as a subform to the Orders Form the combo boxes don't work as they did in the Order Details Form. I can select the Manufacturer fine. When I move to the Product, it tells me to enter a parameter value
for the Manufacturer. The Product combo box is not reading the Manufacturer combo box when I add it as a subform to the Orders form.

I've added the subform manually and with the wizard and I can't get it to work. Any help you can suggest would be appreciated.

 

[ColinEssex]

Sounds like you're not referencing the first Combo correctly from the 2nd one.

How are you referring to the first Combo?

Col

 

[MStef]

Look at CRITERIA in query for PRODUCT combo box.

 

[stampr18]

This is the Row Source in the Product Combo Box

SELECT DISTINCT [QRY-Product].[Product] FROM [QRY-Product] WHERE ((([QRY-Product].[Manufacturer])=[FORMS]![FRM - Order Subform]![Manufacturer])) ORDER BY [QRY-Product].[Product];

 

[boblarson]

SELECT DISTINCT [QRY-Product].[Product] FROM [QRY-Product] WHERE ((([QRY-Product].[Manufacturer])=[FORMS]![YourMainFormNameHere].[FRM - Order Subform].[Form].[Manufacturer])) ORDER BY [QRY-Product].[Product];

 

[stampr18]

Thanks. I will try that.

 

[stampr18]

This is my new Row Source

SELECT DISTINCT [QRY-Product].[Product] FROM [QRY-Product] WHERE ((([QRY-Product].[Manufacturer])=[FORMS]![FRM - Order].[FRM - Order Subform].[Form].[Manufacturer])) ORDER BY [QRY-Product].[Product];

When I select the combo box manufacturer, it still wants me to enter a parameter value but for the manufacturer.

 

[boblarson]

Can you post a stripped down version of your database?

 

[stampr18]

I took out a bunch of stuff and zipped it but it still says it's too big. Can I e-mail it to you?

Nancy

 

[boblarson]

I PM'd you my email address

 

[stampr18]

Thanks. Let me work with it some more. I took alot of stuff out and it's not working like I had it before. If I still need help, I will send it to you.

Thanks for your help. I really appreciate it.

 

[stampr18]

I sent the database to you.