Is there a kind of "move to next record event" in Access 2000 and also how do I make something happen when the TAB key is hit.
Move to next record event.
What I want is Access to perform a action (in this case resting a controls property) when the user changes from the current record in a form to a different one (just as if they had used the Navigation Buttons at the bottom of a form). The record they move to could be either a new one or existing ???
When TAB key is hit.
This is quite simple on paper but I do not know the correct codes to use. I have a simular event that happens using code that a kind fellow forum member posted for me but that is for an event to happen when the enter key is hit. I guess setting it for a TAB hit would be simular.
Just so that you know, here is the code for the enter key hit event: I use "If KeyCode = 13 Then".
Is there a list somewhere that gives theses numbers and the keys they corespond to so I dont have to keep pestering you guys for you precious time?
My grateful Thanks in advance,
David
Move to next record event.
What I want is Access to perform a action (in this case resting a controls property) when the user changes from the current record in a form to a different one (just as if they had used the Navigation Buttons at the bottom of a form). The record they move to could be either a new one or existing ???
When TAB key is hit.
This is quite simple on paper but I do not know the correct codes to use. I have a simular event that happens using code that a kind fellow forum member posted for me but that is for an event to happen when the enter key is hit. I guess setting it for a TAB hit would be simular.
Just so that you know, here is the code for the enter key hit event: I use "If KeyCode = 13 Then".
Is there a list somewhere that gives theses numbers and the keys they corespond to so I dont have to keep pestering you guys for you precious time?
My grateful Thanks in advance,
David