I have a main form "Customers" with 2 subforms "Orders" & Order Details."
In the "Orders" subform I have 2 combo boxes, "Categories" & "Products" When I select a category only the products belonging to that product appear for selection. This all works fine when the subform is open on it's own, but when I have the complete form open and select the categories combo box, a pop up message appears asking for a parameter value. If I click ok without entering anything into the pop ups dialogue box and then select the products combo box every product appears. If I try and enter a parameter then select the products combo box nothing appears.
What the hell have I done wrong???
I have checked, checked and rechecked my code and can't find anything wrong. The code I used was on the Msoft site ACC2000. q209576.
As I said all is fine on the order subform on it's own, it's only when combined with the main form that I get the error message.
I created the subforms at the same time as the mainform with the wizard so it can't be a synchronise issue.
Can anyone please help me?
Billy

Sounds like a forms reference problem.
If your criteria for combo2 says something like Forms!SubformName!Field
then you need to add the main form into the statement Forms!MainForm!SubFormName subform.Form!Field.
Other than that post the relevant codes you are using