Attaching * Wildcard to end of Parameter Query 2

[Dobrmen]

I need some assistance with the following:

I want a user to enter a parameter to query for, and then have Access return all records that partially match.

For Example:
Prompt : Enter CLLI Code?? <user enters> RONKVACS
access then adds the * wildcard to the end of RONKVACS (RONKVACS*) and returns all matching Records.

output would include records matching:
RONKVACSDS0
RONKVACSRS0
RONKVACSDS3

Thanks

 

[PaulF]

instead of using the Parameter, why not use

Like [Enter CLLI Code??] & &quot;*&quot;

in the Criteria Row for the field with the CLLI Code

Paul