subform to a main form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top