[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

OnEnter event in VBA

Posted on 2007-11-28
6
Medium Priority
?
580 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 75
ID: 20366658
Not sure what you are asking?  How does the cmdSubmit  button fit in here ?

mx
0
 
LVL 66

Expert Comment

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

Expert Comment

by:jerryb30
ID: 20366724
AfterUpdate event?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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 - Microsoft MVP, Access and Data Platform) earned 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

656 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