Search for similar results in text box.

[Samer]

I have a form called "Start." In this form

 

[Samer]

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.

 

[Lord Kelvan]

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

 

[Samer]

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

THANK YOU!! IT WORKS PERFECTLY.