I am trying to find a solution to what seems quite an easy task, but it is baffling me.
I have a database which provides a manual back up timing for sports events.
My main form of timing uses an RFID system, linked to a separate database, however I wish to add the manual back up as extra security for the timing.
The database opens with a form called Zone1. Manual input of a race number is added via a numeric keypad. After you have input the race number, the moment you down arrow, the current time, according to the PC is added into the second field, named Time1.
What I am trying to achieve is instead of using the down arrow, is it possible to achieve the same by using the enter key, and if so, how?
Currently, if I input the race number and press the enter key, the cursor simply moves into the second field (Time1), what I would like is when I press the enter key, the current time is input into the relevant record in the Time1 field and the cursor moves down to the next empty record in the ChipID field.
The reason I need this is because the numeric keypad I have does not have down arrows, simply the numbers and an enter key.
Please can somebody help me out with this. I have attached the database (db1).
Thanks in anticipation.
I have a database which provides a manual back up timing for sports events.
My main form of timing uses an RFID system, linked to a separate database, however I wish to add the manual back up as extra security for the timing.
The database opens with a form called Zone1. Manual input of a race number is added via a numeric keypad. After you have input the race number, the moment you down arrow, the current time, according to the PC is added into the second field, named Time1.
What I am trying to achieve is instead of using the down arrow, is it possible to achieve the same by using the enter key, and if so, how?
Currently, if I input the race number and press the enter key, the cursor simply moves into the second field (Time1), what I would like is when I press the enter key, the current time is input into the relevant record in the Time1 field and the cursor moves down to the next empty record in the ChipID field.
The reason I need this is because the numeric keypad I have does not have down arrows, simply the numbers and an enter key.
Please can somebody help me out with this. I have attached the database (db1).
Thanks in anticipation.