I'm having trouble selecting values for "nested" queries. (Not sure if that's the correct term.)
I have a combo box on form that I want to use to select a value to use as criteria to define the rows selected from a table. This is query1.
Query1 data is then used in a crosstab query (query2) that performs some additional filtering.
Ultimately, I want a button on the form that runs query2 and displays the output.
What I'm finding is that the combo box value will work correctly to select the desired rows in query1. However, when query2 runs I get an error that the form combo box is not recognized as a valid field name or expression. This is weird because it's not used in query2 and it works fine when query1 is run on its own.
Am I missing something?
- Dave