Need Help Filtering Combox box on Subform with Data in Combobox on Main form
I am trying to filter a combobox by running a query that contains the data from a combobox on the parent form. How can I reference the Parent forms combobox's value in my query?
Current Query to select all records
Select Part From PartList
I would like to be able to reference the combobox on the parent form so I can do this:
Select Part From PartList where ProductLine = 'PL'
I have attached a screenshot of the form. It is currently an Access 2010 ADP.
screenie.png
Current Query to select all records
Select Part From PartList
I would like to be able to reference the combobox on the parent form so I can do this:
Select Part From PartList where ProductLine = 'PL'
I have attached a screenshot of the form. It is currently an Access 2010 ADP.
screenie.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
master link field cboParts
child link field [ProductLine]