I have two comboboxes in a purchase order form I'm working on (Vendor in main form; Product in subform) with autoexpand on and a Not in List event on each. . . how well will these comboboxes perform in the future when there may be hundreds of vendors and products to choose from? Is there a size limitation or a speed issue I should be thinking of now?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ComboBox Limt?
- Thread starter JeniS
- Start date
hermanlaksko
Programmer
As I know it there is a 2K limit on combo boxes, nut if you expect this much data you should use a form where your users can limit at amount of data in order to get a view that the user can overlook.
The combobox would be too limited.
The combobox would be too limited.
- Status