Using the TAB to go to next fields in a form.
when TAB the last field, it moves to a blank form (new record).
how to set TAB the last field not to create a new record?
can it TAB to the first field? or other solution?
TAB on the last field
Competent Performer
Windows 10 
Office 365
Using the TAB to go to next fields in a form.
when TAB the last field, it moves to a blank form (new record).
how to set TAB the last field not to create a new record?
can it TAB to the first field? or other solution?
VIP
Windows 10 Office 365
In the form properties under the "Other" tab set the cycle property to Current record
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Competent Performer
Windows 10 Office 365
Thanks Minty.
Looking for alternative to the Memo field or Text field for a Comments field
Combine a date field in mm/dd/yyyy format with a text field to produce a field without the date /
Posting Permissions
Reply With Quote