limit records loaded into a combo box

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

Guest

i am trying to save load time in a small buisness. i have a combo box thaat on the third keystroke displays the next 6 records that match the keystrokes. this comes from a table of 5 or 6,000 records. but the whole table loads in the background. there has to be a way to load only the 7 items that follow the match. i am using access 2002. any help would be greatly appreciated
thanks for your time
 
Hello Gramps!

What database engine are you using? If it's Jet, then it's not possible to
load faster by filtering the way you want to do it. If it's MSDE or SQL
Server, then you need to build a stored procedure, pass the keystrokes as a
parameter and have the stored procedure return the handful of records.

I hope that gives you some ideas...

--
Daniel :-)

Computing Technologies International - www.computing-tech.com - We
provide solutions...

gramps said:
i am trying to save load time in a small buisness. i have a combo box
Click to expand...
thaat on the third keystroke displays the next 6 records that match the
keystrokes. this comes from a table of 5 or 6,000 records. but the whole
table loads in the background. there has to be a way to load only the 7
items that follow the match. i am using access 2002. any help would be
greatly appreciated.
 
Back
Top