?
Solved

Prevent current record scrolling to next record whilst using tab key

Posted on 2004-09-30
5
Medium Priority
?
948 Views
Last Modified: 2010-01-27
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
Comment
Question by:pjcrooks2000
  • 3
  • 2
5 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 2000 total points
ID: 12194303
In your form set the .Cycle property (Other tab) to Current Record.

Hope this helps.
-Jim
0
 
LVL 8

Author Comment

by:pjcrooks2000
ID: 12194326
Hello Jim thanks sport I will just try it :)
0
 
LVL 8

Author Comment

by:pjcrooks2000
ID: 12194342
Thank god for people like you ;)

That works a treat and is just what I was after

Muches appreciatosh!
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 12194351
Anytime.
0
 
LVL 8

Author Comment

by:pjcrooks2000
ID: 12194356
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

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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

Implementing simple internal controls in the Microsoft Access application.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

568 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