Phrase Predict?

[Demetious]

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.

 

[CBrighton]

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.

 

[Demetious]

Nevermind, I figured out I have to change it to a combo box and then use the "inherit" property.

 

[Demetious]

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.

Yeah, thats what I did. Thanks for the very fast response!