Search for similar results in text box.

  • Thread starter Thread starter Samer
  • Start date Start date
Sorry, accidentally clicked send.

Continued:

I have a form called Start. In this form I have a text box called
Name. I want a query that search for results in a table called EQD,
containing the text input by the user in the Name text box.

For example, if on my form I enter the word Smith, and run my query-
the results should include those names that contain the word Smith (ie
John Smith, Al Smithson). Is this possible?

Thanks.
 
create a query with the criteria

Like "*" & [Forms]![start]![name] & "*"

then on the event put

object.requery

which is where ever your query is supose to display or if your query
runs only after you click a button then just ingore the object.requery
thing
 
create a query with the criteria

Like "*" & [Forms]![start]![name] & "*"

then on the event put

object.requery

which is where ever your query is supose to display or if your query
runs only after you click a button then just ingore the object.requery
thing
Click to expand...

THANK YOU!! IT WORKS PERFECTLY.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sub form opens before the main form in MS Access 0
Access 2000 append unbound text box values to a table 0
query result in text box 2
Parameter Criteria from a forms Text box - 2003 - not working 5
Query using text from form or anything if empty 2
Query Criteria using Text Box Control 5
Hello happy new year to all, Text box input for year of purchase 0
MS Access problem 0

Back
Top