• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 952
  • Last Modified:

Prevent current record scrolling to next record whilst using tab key

Hi all,

I have many forms to enter jobs into my database.  Generally I am using the Tab key to move through my Main form and SubForms and at the end I move back to the MainFrom to indicate via a tickbox if the job is complete.

However sometimes if I tab too many times the record moves on to the next record and I have put a Button on my form to add a new record.  Is there a way in which I can stop my forms from scrolling to the next record and force the user to use the New Record button.

thanks

pjcrooks2000
0
pjcrooks2000
Asked:
pjcrooks2000
  • 3
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In your form set the .Cycle property (Other tab) to Current Record.

Hope this helps.
-Jim
0
 
pjcrooks2000Author Commented:
Hello Jim thanks sport I will just try it :)
0
 
pjcrooks2000Author Commented:
Thank god for people like you ;)

That works a treat and is just what I was after

Muches appreciatosh!
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Anytime.
0
 
pjcrooks2000Author Commented:
JimHorn please offer some advice on this one

http://www.experts-exchange.com/Databases/MS_Access/Q_21151027.html

If you don't mind :)
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now