I think you need to read the help in VBA on the KeyDown and KeyUp events.
These catch Enter provided the OK button on the form is not set as default.
Keypress does not.

This will catch every KeyUp. You will then need to test to see if it is the
Enter key. It could make your form run slowly.