Hi,
I have a predefined query that a combo box uses for its Row Source, and it works - after a fashion.
The problem is that the criteria in one of the columns in the QueryDef is a value in a Control on a Form. However as that values changes (as the records change), the query is not updating to reflect that, so I need a way in code, to "refresh" or "requery" the query, before the Combo Box displays the results in its Drop Down list.
If I run the Query myself as a user so that it displays the results in a Datasheet, it works fine and displays the correct data each time. However the Combo Box results are only correct the first time it is used, after that that drop down list always displays that same data it did first time, whatever the value of the Criteria Field in the Query.
I have had a stab at trying to update this query before the Combo Box is used, but I keep running into problems, the latest one being the "Error 3065, cannot execute a Select Query". I think I could use some help/guidance with this.
Prof.