Refresh? Requery? Something like that?

[markcrobinson]

Forms!CustomerDisplay has a textbox BSearch and a combobox BsearchCombo
Enter some text in BSearch, Click on the Combobox dropdown with runs a Query on Like Besarch
Enter "mark" in Bsearch and all the records with "Mark" in it show up.
Works great -- once.

When I change the text in the BSearch Box, the query is still running on the old text "Mark" in this example.

If I exit, then reopen access -- works fine.
How do I reset it, refresh it, requery it?

Thanks!

 

[Isaac]

Me.Requery?

 

[markcrobinson]

OK. And where would I put that?
On a LostFocus event on the text box didn't work

 

[Isaac]

how about the after update event of the combobox (if I understand your setup correctly which i'm not totally sure)

 

[jdraw]

For info on these- Refresh Requery
https://sites.google.com/site/accesscodeoverview/difference-among-refresh-or-requery

 

[The_Doc_Man]

Mechanically, what steps in your DB actually trigger the search? What runs the query? Because the Me.Requery or Me.Refresh or whatever would go JUST BEFORE the actual step that runs the query.

 

[markcrobinson]

Ended up putting the me.refresh when the search box lost focus. Works.
The me.requery didn't.
Thank you!