need help simple query criteria question for a simple person 1

[peitzza]

i can get a field in a query to get it's criteria from a text box in a form, but the problem is i have to type in the whole value of the cell, is there any way to type "smi" (for "smith&quot and find all the records that have "smi" in that field. i know this is a simple question but, hey i'm a simple person!       any help would be greatly appreciated! thanx in advance,    peter

 

[Guest_imported]

Create an unbound combo box based on your query and the field you want to use.  Make sure the tools wizard is turned on and select the third option (Find a record on my form based on the value I select).  That way when you start typing it will fill in the field.

 

[peitzza]

sorry, i guess i didn't explain myself well enough. i have multiple names in each record of this field, so if possible i need to be able to search for &quot;smi&quot; and find any record with &quot;smi&quot; in that field, like &quot;joe <b>smi</b>th&quot; ; &quot;<b>smi</b>th's lumber&quot; etc...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;is there any way to do this? i guess what i want is the equivalent to automaticaly inserting *'s before and after my search string.

 

[gol4]

LIke *& forms![yourformname]![yourtextbox]&* in the query criteria

 

[peitzza]

thank you, it worked great! i was trying &quot;AND&quot; but i quess thats something different, again, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you!!!