|
-
Aug 8th, 2005, 04:09 AM
#1
Re: combo boxes - query
Optimisation hint:
If you run a query to fill the list box, then fill it with the other data you want to display on the form, but in hidden columns (column widths of 0).
Then as the user selects the item from the dropdown, you use after update or click events to take the hidden columns data of the selected item and put it into the text box fields on the form. Makes it look faster on seleccting, but a little slower (negligable) on filling the dropdown.
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|