[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

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.
0
CCIG2006
Asked:
CCIG2006
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
jerryb30Commented:
AfterUpdate event?
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
On the command button, set the Default Property to Yes.

mx
0
 
CCIG2006Author Commented:
Thank you!
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now