Search Result

  • Thread starter Thread starter Jean Ulrich
  • Start date Start date
J

Jean Ulrich

Hi
I have a table with 5 different fields. One of the field is named "Other".
I want to type something in an independant text field on a form. Exemple I
type "sta" and I want to obtain a query where I would have all the records
containing "sta" in the "Other" field.
for one of the record it could be "stadium" for another one it could be
"estate" ... all the records containing "sta" anywhere in the field

thanks
 
Hi
I have a table with 5 different fields. One of the field is named "Other".
I want to type something in an independant text field on a form. Exemple I
type "sta" and I want to obtain a query where I would have all the records
containing "sta" in the "Other" field.
for one of the record it could be "stadium" for another one it could be
"estate" ... all the records containing "sta" anywhere in the field

thanks
Click to expand...

Create a Query with a criterion of

LIKE "*" & [Forms]![yourformname]![textboxname] & "*"
 
Back
Top