List Boxes and space

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having an issue with loading values into a list box. We have over
26,000 Vendors we use, and I created a look up, that allows you to click on
teh first letter of the Vendor Name. Once this happens, I send a query to
pull all vendors that have names that begin with that letter and put them in
a list box. Some of them pull out more than 12,000 hits. Should I use
something else other than a list box? The program freezes when this happens.
The database resides on a SQL server.
Thanks.
-Lee
 
I'd try having the user eneter the first 3 letters of the Vendor name,
using...
Like [VendorSearch] & "*"
as a criteria for the list box.
That should get your results down to a workable number.

Or 4 if necessary... etc...

I'd also use a combo instead of ListBox (just a personal choice)
hth
Al Camp
 
Back
Top