combo box on a form query ? Row Source...

[ggreg]

I have serveral combo boxes with queries Example:

Row Source....SELECT [ROUTE].[Route] FROM Route WHERE ((([ROUTE].[Route]) Like "*" & [Enter Search] & "*"));

trouble is or my problem is....the above only allows one search....if you get the search wrong or if you want to
do a diffent search...it won't let you....how can I serach the box more than once....I have try requery...just
not sure how to use clear and refresh and requery to allow more than one search....can someone help me?

Thanks in Advance!

 

[dhookom]

Consider reading faq701-6763.

You can use code to requery the combo box or click the Refresh All button on the ribbon.

I would use a text box on the form to provide the filtering and then requery in the after update event of the text box.

Duane
Hook'D on Access
MS Access MVP