filter data by using a textbox

[Swifey]

A user wants to filter out customers details by keying in only part of the customers name.

Therefore I:-
1. Created a form called Frontpage with a text box called nat
2. Created a Query with the necessary fields
3. In the name field criteria I put - Like "[Forms]![Frontpage]![nat]"

I then asked the user to type in part of the customers name followed by an asterisk.
It brought back zero data but when I put Like”Ba*” in the criteria it returns data.

Can you please advice me as to where I have gone wrong.

Regards
Swifey

 

[bat17]

Try a criteria of,
Like [Forms]![Frontpage]![nat] & "*"
This should give you a partial match

HTH

Peter

 

[Swifey]

Thank you
Swifey