Can you Create new Query from VBA 1

[Olddogg]

I am trying to filter from a last name field.
What I am looking for is to be able to type in: "sm"

and the records that will come up will include:

- smith
- smythe
- smithers

etc.....

I am trying to use the wildcard : * in VBA but it doesn't seem to be working. Does anybody have any pointers?

Currently I am using the DoCmd.OpenForm (then filtering)
However I am only able to type Smith... for all the Smith entries... if I enter Sm... nothing will happen

Thanks
Jon

 

[PHV]

Take a look at the Like operator:
[last name] Like 'sm*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Olddogg]

Thank you so much PH!

Works like a Charm!

Jon