I have an unbound entry form in my Access 2013 application. The user has to enter information about an item, submit the information and then enter information about another item into the same form. This is a high volume data entry process.
Currently I have a 'Submit' button at the bottom of the form. When the user clicks 'Submit', the data is edited and then written to the appropriate table.
All of the entry on the form can be done from the keyboard. The way I have it set up now, after entering the data the user must take one hand off the keyboard and click the mouse on the 'Submit' button. This is slowing them down and they have large data volumes to input.
I thought of having the 'Submit' button be the next tabstop after the last data field on the screen. That doesn't work some of the time becasue some data is optional and they may or may not enter anything into the data field that precedes the SUbmit button in the tab order.
I've never worked with trapping keys strokes to initiate an action but I've seen Access application where it has been done. The one I saw It was set up to submit the data on the screen by pressing the 'PageDown' key.
If I wanted to allow the user to press the 'Enter', 'PageDown' (Or any key) key to submit the form, how and where in the VBA code would I recognize that they pressed the 'Enter' key, so I could take the same actions as though they had clicked the 'Submit' button with the mouse?