Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 942
  • 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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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