Creating a search button

[sevanty7]

Hello,


I currently have very little knowledge on how to create things using VBA code.
My problem I'm having is i have several textboxes and a button labeled search,
what i need to be able to do is have the user enter in information into the textboxes then hit the search button, from there with the use of wildcards a query type setup appears and it gives search results similar to the search criteria.
If anyone can help I really appreciate it. If it's code in which i have to rearrange it to suit my problem i most likly won't be able to figure it out

[June7]

Is this something you have set up? Why isn't it working - error message, wrong results, nothing happens?

Are you using parameterized query? Review http://datapigtechnologies.com/flash...tomfilter.html

[AlexHedley]

You could also check out http://599cd.com/tips/access/multi-field-search-form-like/

A good way is to use the following as Criteria in your Query:
LIKE "*" & TEXTBOXNAME & "*"

--
Alex Hedley
TechHelp Team Leader
599CD.com