OnEnter event in VBA

When a use enters a value in a specific text box and presses the Enter key, how can I have it proceed without the user actually pressing the cmdSubmit button?

I tried the OnEnter event, but it just tabs over to the next text box.
CCIG2006Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
On the command button, set the Default Property to Yes.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Not sure what you are asking?  How does the cmdSubmit  button fit in here ?

mx
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Define 'proceed'.  
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
jerryb30Commented:
AfterUpdate event?
0
 
CCIG2006Author Commented:
For example, if a user enters a user ID in a text box and then clicks on OK, how can I have it so that they only need to press on the <Enter> key instead of clicking on the OK button?

I hope this makes more sense.
0
 
CCIG2006Author Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.