Field Search in a Form?

[jbeling]

Is it possible to place a text box where I can search for a field in a query that has unique records (no record is the same in this fiels). Basically i am looking for a simplified "Find" box where i can type in the search criteria and click find. It works perfect when I use the "Find/Replace" box but I would prefer something that is just one text box in the form with a search button.

THanks!

 

[Alansidman]

Look at this tutorial. Then when you create your own, use only the one text box, but have each of the fields in your query look to that text box on your form. Be sure to put the criteria for each field on a different line, because you want it to search using "Or" and not "And". I think with a little imagination after viewing this you can adapt it to your needs.

http://www.datapigtechnologies.com/flashfiles/searchform.html

Alan

 

[jwhite]

In addition, see this thread.