If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Datasheet view subform
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. |
Thread Tools | |
Display Modes | |
|
|