Using wildcards in query prompt form

[Tony Williams]

I have a user prompt form in which the user inputs a word or phrase say
*reg* using * as the wildcard into an unbound control. On pressing a command
button which runs a query it returns any record where the control they are
searching includes the letters reg into a form which is based on a query
where the parameter of one of the fields uses the function "Like". Is it
possible to include more than one word in my prompt form so that eg the user
can input "*reg* and *dti* (using "and" or "or" ) so that they get all
records where the control includes the letters reg and/or dti?
Any help would be appreciated
Tony Williams

 

[Guest]

*[Enter First]* or *[Enter Second]* - enter this under Criteria in your query.