Updating RowSource during entry

StevenBee

New member
Local time
Today, 12:13
Joined
Jan 6, 2011
Messages
7
I am using the onChange Event in a listbox to continually narrow down from a list of phone numbers, so that if you click when it's empty, it shows every phone number in the table it's looking up, if you type in the first number of the area code and click the down arrow, it just shows all the phone numbers that start with that one number, and continues to narrow as you type in numbers.

My fear is that as the table it's looking up grows to many thousands, and perhaps tens of thousands of entries, that this many lookups will cause delays in typing in every number.

Is there a more eloquent way of doing this, or will this not be an issue (I'd be fine with a maximum of a few milliseconds recalculation between keystrokes)?
 
Use the AfterUpdate event or get the user to click a button after typing.
 
I'm using 2010 so shouldn't be an issue there. Thanks a lot for the suggestions & the article guys - looks like that article covers exactly what I need to do.
 

Users who are viewing this thread

Back
Top Bottom