Form for linking Subform to Form

[stampr18]

I asked this question last week and was told I didn't have the subform properly linked but I don't know how else to link it. Here's the problem.

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.

Any help would really be appreciated.

Nancy

 

[deville75]

I'm sorry I won't be of much help, but I had the same problem when I tried to filter a form bounded by a table. I think you may need to change some of the coding you've done, I'm not exactly sure how, but try doing something like Me![Subfrom Control Name]![Controls within Subform].. That is, if i understand your question correctly.

 

[Fifty2One]

are the orders and details stored in separate tables or on one table?
make sure the form is only referal to one table and the subform referal to one table for your updates