Phrase Predict? (1 Viewer)

Demetious

Registered User.
Local time
Today, 07:46
Joined
Sep 7, 2010
Messages
48
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

Surfing while working...
Local time
Today, 11:46
Joined
Nov 9, 2010
Messages
1,012
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

Registered User.
Local time
Today, 07:46
Joined
Sep 7, 2010
Messages
48
Nevermind, I figured out I have to change it to a combo box and then use the "inherit" property.
 

Demetious

Registered User.
Local time
Today, 07:46
Joined
Sep 7, 2010
Messages
48
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!
 

Users who are viewing this thread

Top Bottom