Link to home
Start Free TrialLog in
Avatar of Dennis_Gundersen
Dennis_Gundersen

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of omgang
omgang
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
....so if you have the properties dialogue open, select the Other tab.  There you will see the Cycle property.
OM Gang
Avatar of Dennis_Gundersen
Dennis_Gundersen

ASKER

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
Perfect!
You're welcome.  Thank you!