This is probably pretty simple but I can't get it. I have a text box on a form called tb_Item. I simply want to go to that textbox, start typing, and if the Item exists, it will autofill the text box. Any help would be great, thanks.
One solution would be to change it into a combobox with the rowsource set to a query displaying the unique values from a query based on the field you want to search.
However, as you get more and more records phrase predicting can cause serious slowdown, even on an indexed field.
One solution would be to change it into a combobox with the rowsource set to a query displaying the unique values from a query based on the field you want to search.
However, as you get more and more records phrase predicting can cause serious slowdown, even on an indexed field.