Part of field as a parameter 2

[ajduk1]

Hi
I have a form based on a query that has a parameter [Enter customer]. This relies on the user entering the exact customer name. Is there a way I can modify this so they can either enter part of the customer name eg "A" to bring up all customers starting with A, or enter the exact customer name to bring up the specific customer.

 

[PHV]

You may try the following criteria:
Like [Enter customer] & '*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ajduk1]

Thanks
That works great.