Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2016-08-26
5
Medium Priority
?
52 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 2000 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
0
 
LVL 28

Expert Comment

by:omgang
ID: 41772203
....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
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!
Re
D
0
 

Author Closing Comment

by:Dennis_Gundersen
ID: 41772221
Perfect!
0
 
LVL 28

Expert Comment

by:omgang
ID: 41772244
You're welcome.  Thank you!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

824 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