- User opens form, selects value from combo box
- combo box value changes criteria in query
- Subform lists query results based on that criteria
What is the simplest way to do this? I thought this would be simple but I haven't been able to figure this out. I have a lab book with examples of different forms and queries, but nothing about interactive query based forms.
I'm having trouble with this... it sounds simple enough, and I'm referencing my form's combobox in the queries criteria. I tried several different ways of refreshing the form and query and nothing changes. I still get my query without criteria.
Ah, nevermind, I got it. For some reason during my testing, I messed up and was loading my subform using the table directly instead of the query that had the combobox as criteria. And instead of using a requery, I needed to use a refresh.