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.