Select records based on a text box

[cantona]

I have a form which contains a text box entitled [SurnameSearch]. When a user enters a surname a query is run to select the relevant records. The query uses the criteria below;


Surname = [Forms]![New_archive_search]![SurnameSearch]

This works fine where the user types in the surname exactly correct. However it returns no records if they dont spell it exactly the same. How can i amend the query to bring back records which are similar to what the user has entered, or even surnames beginning with the same first few letters?

 

[jrbarnett]

To match the first few characters:

Surname Like [Forms]![New_archive_search]![SurnameSearch] & "*"

To match one character, you can use a ? character.

John