Update a form bound to dynamic query

[Obe]

I have a form bound to a dynamic query. It is similar to a search function, the user enters a keyword and the query is updated, however the continuous form does not show the updated query results unless the form is closed and reopened. Requery methods do not work. It's something simple but I'm missing it. Any ideas?

 

[dansc0tt]

Are you sure that you have referenced the control that you are trying to requery correctly?

Take a look at this page if you are unsure
http://access.mvps.org/access/forms/frm0031.htm

 

[boblarson]

Requery methods do not work.

Post the actual "requery methods" you have tried which do not appear to work and where you have used them (what event/events).

 

[Obe]

Bob/Dan,
Thanks for the quick reply. After walking away from the screen and having a nice Manhattin, I came back, stared at the code and recognized the issue. I put in Me.Form.RecordSource = "qryGetTasks3" after the code for building the dynamic query. That updates the form for me.

Thanks again for you quick reply.
Obe