proper usage of keycode

[crowegreg]

I have the requirement that in order to save the record, the used needs to press enter. Using the keycode I can determine if the user presses enter or some other key. If they press some other key, how do I stop all code within this text box from executing and return the focus to this text box? Thanks in advance!!

[pbaldy]

I'm not clear on the goal, but you can negate the input by setting the key variable to 0.

[crowegreg]

I tried that, and the result it didn't seem to work. The customer wants the employee to only press enter to save the record. I'll try it again.

[pbaldy]

Post the code if you don't get it working.

[crowegreg]

Here's what the customer would like, after the user has entered data, to save the record and advance to the next record, the user can only press enter. Within the properties of the text field their are events in the after update, on got focus, on lost focus. I've enter keycode command in the key down event.

In my testing, I've entered the following code within the key down event:
if keycode <> "13" then
msgbox "You are required to press the enter key"
end if

But then the code goes to the after update event

What do you think?

[pbaldy]

I'm not on a computer right now but I think you want the key press event. And set the variable to 0.

[crowegreg]

What do you mean by set the variable to 0?

[pbaldy]

Keyascii = 0

[crowegreg]

Thanks!! I think that will do it

[pbaldy]

Happy to help!