catch a key on form open?

[rmanchu]

hi

i've got a form which is backed by data stored on a mssql server, and
the data is retrieved via the internet.

the table is getting bigger and is now taking time to load the form.

all records in the table are timestamped

now what i want to do is:

if a user has pressed a certain key during form load (via button click
in a Switchboard), i want to be able to catch that key press in the
FormOpen event and alter the SQL to reduce the number of records that
are loaded by only loading records that are recent (using record
timstamp).

how could i do this? perhaps theres a better way to do this?

thanx
riyaz

 

[Michel Walsh]

Hi,

Why not the reverse, load ONLY few records by default and have a button,
"More", to load the whole set of records. So, by default, you will get only
few recent records, fast to load, and if the end user want to see every
thing, then clicking the button would be the way to go.

Otherwise, it seems you have to kill an action already occurring, ie, the
server already got the command to download all the records, and you would
have to stop it. I doubt it is easy to do.



Hoping it may help,
Vanderghast, Access MVP