limit records loaded into a combo box

[gramps]

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

 

[Daniel Carollo]

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...

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.