Access: How to keep form on single record (tab should not jump to next record)?

Posted on 2016-08-26
Last Modified: 2016-08-26
I have a form set to "single form", but when I've tabbed through all the controls it still jumps to the next record (form's record source is a table). How do I stop that and make the focus jump back to the first control in the current record instead?

Question by:Dennis_Gundersen
  • 3
  • 2
LVL 28

Accepted Solution

omgang earned 500 total points
ID: 41772202
In the Form properties, set the Cycle property to Current Record.  By default, it's set to All Records.
OM Gang
LVL 28

Expert Comment

ID: 41772203 if you have the properties dialogue open, select the Other tab.  There you will see the Cycle property.
OM Gang

Author Comment

ID: 41772220
That is awesome, and it even worked with sub forms (I've got one where 99% of the time there is only one sub row needed).
Thanks a lot!

Author Closing Comment

ID: 41772221
LVL 28

Expert Comment

ID: 41772244
You're welcome.  Thank you!

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How Can I Grab This Information off a PDF Form 23 48
Attachment field in SQL 3 28
Combobox row source 2 20
ms access filter query with empty combobox 5 29
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

770 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