Using wildcards in a popup

  • Thread starter Thread starter Peter MacInnis
  • Start date Start date
P

Peter MacInnis

I made a query that uses a popup box where people can
enter their request. The information in the text field
contains several words to describe a course. There are
several course titles with the name "Access" in it. I want
to be able to list all the records whose Course field
contain the string "Access". Thanks

Peter MacInnis
 
Hi Peter

The syntax in the query would be as follows:

Like "*" & [txtField] & "*"

will pick up all occurences of any string that is entered.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
Ottawa, Ontario
 
Back
Top