Solved

Access 2010 Enter Key Closes DB in Form View

Posted on 2014-01-23
1
433 Views
Last Modified: 2014-01-29
Hi Experts,

I can't figure out what I did to my forms so that when Enter is pressed, the DB is closed.  The forms titled "Old.." in the attached file don't do it so I'm assuming it's something in the new forms I've created.  Thank you in advance for you help!
Menus.accdb
0
Comment
Question by:Skip Sleeper
1 Comment
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39805225
it is the form "frmSwitchboard"
the control that is having the focused is the "cmdQuitAccess"

so when you hit Enter it closes  your db.

changed the Tab order of the controls, so that the  "cmdQuitAccess" is not the one active when you open your form "frmSwitchboard"


the other command button "Items" also have the command to quit access.
you need to change the code to do what it should do
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

685 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