same query for list box different filter on mulitple forms 1

[JaredTaylor74]

I have a list box pulling from a query, I want to put this list box on multiple forms and filter it by the moldsetid on each form. I don't want to have a bunch of queries that are the same except for the filter... so i want them all to pull from the same query, just filtered by the form... how do i do this?

Thanks,
Jared

 

[FancyPrairie]

To make it work, set the moldsetid control name to the same name on each of the forms (i.e. txtMoldSetId). Then set the RowSource property of the list box to something like this:

SELECT ... From ... Where (moldsetid = [txtMoldSetId])