I have a tabbed subform (data sheet view) for which one of the controls is a combo box. It is based on a query that needs to be filtered by the same field data linking the main and sub forms.
I get a parameter entry box which asks for the value and then retains that value when the parent form records are scrolled thru.
I have created a specific query fort the combobox recordsource and have tried several modifications to the WHERE part of the sql statement with no success.
The query is trying to run before before focus is pointed by mouse to any of the records. How can I have the query run only when the combobox is pulled down?
Any help would be appreciated. I have spent better part of two days searching and trying to figure this out.