Solved

Prevent current record scrolling to next record whilst using tab key

Posted on 2004-09-30
5
935 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 65

Accepted Solution

by:
Jim Horn earned 500 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 65

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

808 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