Problem with Enter Key action .. in Unbound Form

[edmscan]

I have the most annoying problem. I have an unbound form .. and when I am entering data and press Enter, the form fires the Click event of a Command Button that runs a SQL Insert. (this button is not even a TAB stop at all).

If I press Tab ... there is no problem. But I am used to pressing Enter .. and I want to go to the next Field in the form and not fire off the Command Button til all the data has been entered.



I want to manually fire the Command button .. usually with a mouse click when all the data has been entered. (basically I would like the Enter key to act like the Tab key).

Anyone have any ideas ?

[June7]

That should only happen if the button has focus.

If you want to provide db for analysis, follow instructions at bottom of my post.

[edmscan]

That should only happen if the button has focus.

If you want to provide db for analysis, follow instructions at bottom of my post.

I will see if I can replicate the problem in a test database.

[edmscan]

Test.accdb

If you go from First Name .. to Last Name via Tab it is fine. If you press Enter from First Name .. you fire the command button.

[June7]

This is bizarre. I tried to replicate behavior in one of my dbs and can't. I built a new form in your db and do not get the issue. I deleted your button and created new button. Do not get the issue.

[edmscan]

I found the problem .. Google is my friend. Re the below link .. the 2nd post was my answer. The default property of the 'Command Button' was set to YES .. and that is what is causing the problem. If it is set to NO .. the enter sends focus to the next field. I learned something .. which is never a bad thing. I tested it on the above database and it works fine now.

http://bytes.com/topic/access/answer...enter-text-box