Help with textbox filter please...

[ajk825]

Hi... I have a project that I am required to write using Ms Access 2013. It involves filtering a table using a textbox instead of the Search box provided in the navigation strip. I have it working, but I'm not happy with it...I'm currently using a Macro set up with a button to filter the text box on the buttons OnClick() command. The Where clause is this:


WHERE = [RECIPE]![RecipeName] Like [Forms]![RECIPE_FEED_BK_FORM]![lookUpTxtBx]


Which filters the table as I hoped...but the name I am looking for must be spelled exactly as it is in the database or it does not work...Isn't there a way for it to narrow the search as I type? I mean that if I type an "a" all the records starting with "A" appear. If I add a "p" then it is "Ap"...and so on.... Is this possible and what would be the best way of doing this? Thank you in advance.

[June7]

Could try a combobox instead of textbox. Combobox autoexpand property will match to listed items as you type.

LIKE without wildcard might as well just be = sign and the = sign you have shouldn't even be there.

WHERE [RECIPE]![RecipeName] Like "*" [Forms]![RECIPE_FEED_BK_FORM]![lookUpTxtBx] & "*"

[ajk825]

Had to use a textbox, but thank for the above it cleared it right up for me... had the wild cards in the wrong spot..