subform to a main form

[Guest]

I have a combo box on a subform that I need to fill depending on the
selection from a combo box on a main form. The query I have is working and i
son the subform combo. But where I have the problem is in the WHERE clause.
The clause has the following;
(((tblSubProcessComponents.SubProcess)=[Forms]![PRADetail]![SubProcess]))
Mainform = PRADetail
Subform = PRAComponent
Mainform combo = SubProcess
Subform combo = Component

The WHERE is not specifying the mainform correctly and I can not figure it
out. Asking for assistance from anyone in the know. And, thanks for the
reply.
*** John

 

[Ken Snell [MVP]]

Try this:

[Forms]![PRADetail]![PRAComponent]!SubProcess]

Note that PRAComponent must be the name of the main form's control that
actually holds the subform object.