Problem with Cascading Combo Boxes in a Subform

[Jo22]

Hi! I am new to this forum and to MS Access. I am hoping someone can help me with this problem I have been struggling with all day.

I have a main form [Quote Details] with a subform [Quote Query].
The subform has the following cascading combo boxes which are bound to controls on the subform:
[cmbSupplier], [cmbProduct], and [cmbPattern]

[SupplierID] Rowsource = SELECT [Suppliers Query].ID, [Suppliers Query].Company FROM [Suppliers Query] ORDER BY [Suppliers Query].Company;

[ProductID] Rowsource = SELECT [Products Query].ID, [Products Query].[Product Name], [Products Query].[Supplier ID] FROM [Products Query] WHERE ((([Products Query].[ID])=[Forms]![Quote Details]![Quote Query]![cmbSupplier]));

PROBLEM: When I open the main form [Quote Details], it opens just fine with all the subform fields blank. I go to the subform, click on the [cmbSupplier] and select the supplier. When I press enter, a message box pops up Enter Parameter Value: Forms!Quote Details!Quote Query!cmbSupplier. If I enter the SupplierID in this box again, the cmbProduct populates correctly.



My question is: How do I stop this popup? I do not understand why it asks me for the parameter value when I just entered it.

[cap.zadi]

Hey,

Go through from article and it will help you to understand the relationship of Main form to sub-form.

http://social.msdn.microsoft.com/For...7-1a9d045b3400

If still did not solved so please post the project here and will do for you.

regards

zee

[cap.zadi]

I am sorry.

Joe you are welcome to this forum. i am sure will have good experience.

best regards

zee

[Jo22]

Thanks a whole bunch Cap.Zadi! The link you suggested was perfect. I changed the name of my subform Control to Quote Query, the same as my subform name, and it worked like magic.

Oh, by the way, that is Jo (female) not Joe (male)

[cap.zadi]

Your are welcome. oh i apologize for that error.

If your problem is solved so please mark the thread as solved.

have good time.

zee