Hi
have a simple form with a text field and a button.
The user is asked to type in a Surname and then press the button.
The onclick event of the buttom runs a macro that created a temprary variable of the value of the text field.
The macro then opens a query with the criteria
this works perfectly and lists all records with say the exact name "Smith"Code:[TempVars]![varSurname]
I'd like to modify the search so that it would also list
smith-jones
and also if someone typed in
smi
it would show all surnames beginning smi ie smith, smithenson, etc etc
Is this possible with what I've got by modifying the criteria or am I better to create a wild card search as in http://allenbrowne.com/ser-62.html
thanks
Ian