How to connect Enter key to Submit button

Question

I'm building a data entry form that includes a Submit button which runs a script. This works fine, but I'd like to take the extra step.

In my experience with most web forms, the Enter key can be tied to a certain command, regardless of the cursor location in the form. I'd like the enter key to be tied to this Submit button. Then, regardless of which field currently has the focus, hitting Enter will run the Submit script.

So, how do I tie the Enter key to the Submit button?

My best guess is to make an OnKeyPress event for every single enabled text box. For obvious reasons, I'm hoping there's a better way.

Answer 1

You can set the OnKeyPress of the FORM to capture if it's the "Enter" key that's pressed, and if so then run the Submit script.

Key Preview=Yes

Private Sub Form_KeyPress(KeyAscii As Integer)
    If KeyAscii = vbKeyReturn then
        ...Submit script
    End If
End Sub

EDIT: You may need to play with that a bit, because you might actually want it on the KeyDown event. I think if you're on a TextBox then the Enter key won't work, so you might have to put it in KeyDown.

Answer 2

how do I tie the Enter key to the Submit button?

Set the .Default property of your "Submit" button to Yes. That should make the Enter key click the "Submit" button in most circumstances. (Similarly, the .Cancel property for a command button will associate it with the Esc key.)

Answer 3

1. Change the "default" property to true for the "OK" button
2. Change the "cancel" property to true for the "Cancel" button
3. No keypress monitoring needed