How to have a partial match on form?

[jgomez]

Good morning, I have a query that has [Forms]![FORM NAME].[FIELD NAME] that works well when the user enters the exact information. I would like for it to bring back partial matches so I tried Like [Forms]![FORM NAME].[FIELD NAME] & "*" & even tried Like *[Forms]![FORM NAME].[FIELD NAME]* but the query just runs & in the 2nd case it doesn't work. Does anyone know how I can edit this deal so it can bring back partial matches???

[alansidman]

I use this regularly and don't have an issue.

Please Login or Register  to view this content.

If you use the above as you indicated and in your form type "Al", then it should bring back everything that begins with Al. Is your issue one of using a combo box field on your form. If so, then you will need to change things up just a bit. Please advise if this is the case.

Alan

[jgomez]

I had it backwards... I changed it to

Please Login or Register  to view this content.

... the text I enter is at the end not the begining like you indicate in your example.