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!!!

 

[jon98548]

Open your form in design view. Open the properties box. Click on the subform. Click on the data tab of the properties box. You should see 'LinkChild Fields' and 'Link Master Fields'. Select ProductID for both of these and it should work. That should show you batches for that ProductID.