Mike Yearwood
Toronto, Ontario, Canada
SEE????
Wow, fact comes back to haunt me. I just discussed how people should not be putting so much stuff in a combobox, and here we are. :)
>>Are the data in the combobox static? If so, you could pull all the data across into a local cursor when your app starts and leave it there, ready to be used in your form.
>>
>>If not, and you have to freshly query the backend for each incremental seek, it's more challenging. Some possible strategies:
>>
>>1. Re-query the backend after each keystroke. Probably slow, and likely not necessary.
>>
>>2. Employ a separate text box, where the user types in the "search" string. Only after they leave that text box do you update the combo box contents. Most efficient but adds extra controls to the form.
>>
>>3. Same as #1, except you implement a timer so that queries happen only if the user pauses for "x" amount of time i.e. not while they are in the middle of typing multiple characters.
>
>Actually, you can do this without timer. Set a property of the combo to be equal to seconds() in each .keypress or .valid (i.e. whichever events happen when user changes the value by typing or mousing), and check against its previous value. If greater than _dblclick, user is waiting.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only