Using Left function in Query criteria

[bren11]

I am wanting to use criteria that matches only the left 3 characters of the value in an input box on a a form, but am not having much luck...syntax I am using is

Like Left([Forms]![frmMyForm]![txtMyTextBox],3)
or just

Left([Forms]![frmMyForm]![txtMyTextBox],3)

but it's not returning any results. Any ideas would be greatly appreciated!

Thanks

 

[WayneRyan]

Bren,

Try:

Like Left([Forms]![frmMyForm]![txtMyTextBox],3) & "*"

HTH,
Wayne

 

[bren11]

Thank you, Wayne, you rock! Works beautifully!