Filtering Subform Query

[Jeff_Ford]

I have a query (qryBatch) that queries information from a table (tblBatches) this, query is the record source for a subform (frmBatch) within a main form (frmMainForm). On the main form there is a combo box (Product I.D) which should be used to filter the information within the subform through the query, so only results for the selected product ID are displayed within the Sub Form, How is this done?

I have attached it here if somebody can help I would be very greatful!!!

 

[Oldsoftboss]

the query was not the record source for the subform, tblBatch is.
I added the field ProductID to the Subform and linked the master/child links between the form and subform.
Hope this is what you were looking for.
Dave