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

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
Dennis_GundersenAsked:
Who is Participating?
 
omgangIT ManagerCommented:
In the Form properties, set the Cycle property to Current Record.  By default, it's set to All Records.
OM Gang
0
 
omgangIT ManagerCommented:
....so if you have the properties dialogue open, select the Other tab.  There you will see the Cycle property.
OM Gang
0
 
Dennis_GundersenAuthor Commented:
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
 
Dennis_GundersenAuthor Commented:
Perfect!
0
 
omgangIT ManagerCommented:
You're welcome.  Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.