Wild card name searching help

[gomes.]

How would I make a query find a person like this:

Inputted Data: Smit
Outputted Data: Smith, Smithy etc..

The formula I have entered in the criteria of my query is:
Like [Enter the person's last name]

With this formula, if I type Smith, then the data that comes out is Smith. But if I type in smit or smi, Smith doesnt come out.

Thanks.

 

[neileg]

You haven't used the wildcard, though.

Like [Enter the person's last name] & "*"

 

[MStef]

Trey this;
Like [Enter the person's last name] & "*"

 

[neileg]

Snap!

Actually, an alternative is to use a combo box in a form. Part of the standard functionality of a combo is that it zooms to a value as you type.

 

[gomes.]

Thanks, repped you both.