Create Search function for dummies?

[naomimsm]

Seriously newbie question: I'm trying to build a search function
into a form. Ideally when the user clicks the "Search" button on
the Search Customers form it will use the information typed into the
txtCLSearch unbound text box on the same form and search to find a
match for it in the Customer Location column on the Contacts table, and
then return the results in the Customers form. Is this expecting too
much for a novice with no VB experience to create? And if so, are
there any non-VB workarounds that you would suggest?

I've gone through the messages on this board for the last few hours
and tried the suggestions but none of them have worked for me (my lack
of VB experience doesn't help!) Thank you!

 

[Guest]

It might be simpler to use the txtCLSearch unbound text box as criteria in a
query. Have your button run a macro that 'Requery'

 

[naomimsm]

Would my button requery the control name txtCLSearch if I set up the
macro as above? How would I get the results to post back in the
Customers form, not the Search Customers form? Thanks for any advice!

 

[Guest]

Read the help for macro command Requery.