i'm trying to do a real simple name search. i've created a basic query and i'm using this as my criteria :

Like [Forms]![Fseptic]![TxtClientName]+"*"

what i need is to be able to look up any records that contain what ever i type in my text box. this only looks up the first part of my names. i need the ability to look up any names that have any of the letters i choose to search by. i just need the correct syntax here. does anyone know what it is?

If you want any of the letters, but in the order that they were typed in, change your query criteria to:

Like "*" & [Forms]![Fseptic]![TxtClientName] & "*"

+ should only be used to add integers. & is to concatenate strings.

If you want any of the letters in ANY order, we can do that too. Just let me know.





mmcdonal