Solved

OnEnter event in VBA

Posted on 2007-11-28
6
556 Views
Last Modified: 2011-09-20
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.
0
Comment
Question by:CCIG2006
6 Comments
 
LVL 75
ID: 20366658
Not sure what you are asking?  How does the cmdSubmit  button fit in here ?

mx
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 20366715
Define 'proceed'.  
0
 
LVL 26

Expert Comment

by:jerryb30
ID: 20366724
AfterUpdate event?
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:CCIG2006
ID: 20366759
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
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 20366789
On the command button, set the Default Property to Yes.

mx
0
 

Author Closing Comment

by:CCIG2006
ID: 31411446
Thank you!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now