Force a requery on Find?

[Sandra]

Hi there.

(Related to my record refresh post)
Is there anyway I can modify the Ctrl+F event/keystroke?
I want to add code so that when a user types ctrl+f to
find, the form's underlying recordsource (a linked table)
will be requeried before the Find (the normal Access find
window) is allowed to execute, this way they are
searching the most current recordset. How can I do this?

Thanks in advance!

 

[Bruce M. Thompson]

(Related to my record refresh post)

Is there anyway I can modify the Ctrl+F event/keystroke?
I want to add code so that when a user types ctrl+f to
find, the form's underlying recordsource (a linked table)
will be requeried before the Find (the normal Access find
window) is allowed to execute, this way they are
searching the most current recordset. How can I do this?

Look up AutoKeys in Access Help for information on reassigning combination
keystroke actions.