Solved

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

Posted on 2016-08-26
5
24 Views
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?

TIA!
Dennis
0
Comment
Question by:Dennis_Gundersen
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

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

Expert Comment

by:omgang
Comment Utility
....so if you have the properties dialogue open, select the Other tab.  There you will see the Cycle property.
OM Gang
0
 

Author Comment

by:Dennis_Gundersen
Comment Utility
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!
Re
D
0
 

Author Closing Comment

by:Dennis_Gundersen
Comment Utility
Perfect!
0
 
LVL 28

Expert Comment

by:omgang
Comment Utility
You're welcome.  Thank you!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now