Hi

I have a customer table in my Access 97 mdb file that I downloaded from my
company's database.

I am developing my apps using Microsoft VB 5 Enterprise edition.
I tried to use combo box and additem to populate my combo box with Customer
name(string 80) and customer number (string 15) but it took very long time.

I then tried DB combo box with data control that connected to my mdb. This
worked  but it took about 4 seconds refresh my data control.

Can anybody show me a better way to make my data control refresh faster ?

Regards

John

Don't use the bound controls, if possible at all. And open your recordset using the
dbOpenForwardOnly, if possible. Adding so many items to a combo is bad design, IMO... who
would want to search through a 14,000 item combo box? You best option is to create a
single-row recordset using a stored querydef with a parameter applied to the key field,
and validate your user's entries against that. You can also perform proximal searching on
the recordset to bring up related records (i.e., those that start with an "A", or
something), and show those as a pick list. Anyway, use you imagination. But don't make
your users suffer! :-)

~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please post/reply to the newsgroup(s) so
that everyone can benefit from the discussion.

Regards,

Klaus H. Probst, MCP


       ICQ: 22454937
~~~~~~~~~~~~~~~~~~~~~~~~~~~