Running a changed select Query from code in an active form

[GeorgeJ]

I am exploring this issue in another forum (Programming) and thought I would also post here in the Query form. The situation is this. I am trying to avoid using the filter properties of a form. I have a form F_Lists whose record source is the query ListQuery. Based on what the user types in a textbox which is on F_Lists, VBA code changes the SQL string of the query ListQuery. Then code runs a Requery and Refresh command. But the records shown in F_Lists do not reflect the fact that ListQuery has been changed. However, if I leave the form and then reload it I do get the results of the changed query. My question is, are there any VBA commands which I can put into the code file of F_Lists which will cause the program to run the changed query and show the results in the records shown in the form, without closing and reopening the form? (When I try the Execute command I get the message that this command doesn't work on a select query).

Thank you in advance

[June7]

Why aversion to setting Filter property?

If you have code that modifies QueryDef and Requery of form (I would not do this and never tried) doesn't work, then possible option is to set the form RecordSource property with the SQL statement instead of reference to query object.

[orange]

Suggest you show some code you are using.

[GeorgeJ]

Thanks for your response. I'm continuing this thread on another part of the forum.