I think I know the answer to this one but I'll ask it anyway.
Is there a way to use a combobox.rowsource as the input to a query, rather than build a new query every time.
To explain:
My form is used with 6 different tables. That means 6 queries for a combobox and another 6 queries to reduce the results to one instance of each.
For instance query1 returns 1,1,1,1,2,2,2. using query1 as input for query2 my combobox only shows 1,2. Both query1 and query2 are aggregate queries.
Can this be achieved with the combobox.rowsource, ?
Is there a way to use a combobox.rowsource as the input to a query, rather than build a new query every time.
To explain:
My form is used with 6 different tables. That means 6 queries for a combobox and another 6 queries to reduce the results to one instance of each.
For instance query1 returns 1,1,1,1,2,2,2. using query1 as input for query2 my combobox only shows 1,2. Both query1 and query2 are aggregate queries.
Can this be achieved with the combobox.rowsource, ?