QBE using text box, but with concantenated text

[janerussel]

I want to filter records on my form based on what the user types in the text box. The text box is a name field. The user would like to be able to just type part of the text string, i.e., "sm" for "smith"

How do I show this in the criteria in my query.

Normally I would show the criteria like:

[forms]![frmMain]![frmAgree]![txtName]

Normally it would look something like ="**"&[txtName]&"**"

 

[Databaseguy]

Make the text box unbound.

In the query:Like "*" & [forms]![frmMain]![frmAgree]![txtName] & "*"

Then, a command button on your form. Me.Requery.

That's it !!

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[janerussel]

Thank you, worked like a charm.

I was wondering if you could have two text fields that you would like to the same thing with on one form, i.e., "name" and "description".

How would that be handled on the on the criteria.
Could you do that?