i'm trying to build a search form where you can enter part of a surname in a text box and a query will find all records that include that string

in the query if i type:

like s*

in the criteria it will show all records beginning with s

if i type

like [Forms]![Form1]![Surname]*

it will only show records that exactly as they were typed. can anyone explain to me why it is doing this and how i can acheive my goal? i feel like i'm missing something simple

thanks

CB

CB, try this:

like [Forms]![Form1]![Surname] & "*"

Thanks mate that was exactly what i needed. its working now

thank you

Very good then. You're welcome. I am glad I was able to help.