Link to home
Start Free TrialLog in
Avatar of CCIG2006
CCIG2006Flag for Canada

asked on

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.
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Not sure what you are asking?  How does the cmdSubmit  button fit in here ?

mx
Define 'proceed'.  
AfterUpdate event?
Avatar of CCIG2006

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you!