Datasheet view subform

I have a datasheet view subform and a text box on a main form. The text box
is unbound and the recordsource of the text box is based on a query that
uses a selected record as a parameter from the datasheet view subform to
filter out the records. I can requery and refresh the content of the text
box using "Click" event on the datasheet view subform and on each of the
controls on that subform. Somehow I don,t know how to activate this action
(Requery and refresh of the text box) when user navigate the records using
the keyboard. Are there any events on the datasheet view subform to trigger
off an "Event" when a key on the keyboard is pressed.

The form's Current event will fire each time you move to a different record.
The controls' GotFocus/LostFocus and Enter/Exit events will fire as you move
from field to field. The Enter event occurs before the GotFocus event and
the Exit event occurs before the LostFocus event.

--
Wayne Morgan
Microsoft Access MVP


"Paul" wrote in message
...
I have a datasheet view subform and a text box on a main form. The text
box
is unbound and the recordsource of the text box is based on a query that
uses a selected record as a parameter from the datasheet view subform to
filter out the records. I can requery and refresh the content of the text
box using "Click" event on the datasheet view subform and on each of the
controls on that subform. Somehow I don,t know how to activate this action
(Requery and refresh of the text box) when user navigate the records using
the keyboard. Are there any events on the datasheet view subform to
trigger
off an "Event" when a key on the keyboard is pressed.