Use the Keyboard to Move Up and Down Between Records

In this video I'll show you how you can use keyboard shortcuts to navigate up and down through records in your Microsoft Access databases.

Juan from Yokosuka Navy Base, Japan (a Gold Member) asks: I would like to be able to move up and down in my continuous forms just like an Excel spreadsheet using the keys. Is this possible in Access? Right now the up and down arrows just move between fields.

Members

I'll show you how to use the KeyPreview form property to intercept special keys, like the arrow keys. We'll learn about the KeyPress and KeyDown events and the special KeyCode constants. We'll make your form truly behave like an Excel spreadsheet where users can move up, down, left, and right with the arrow keys.

• Extended Cut Video - Silver
• Database Template Download - Gold

Silver Members and up get access to an Extended Cut of this video. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to contact me so I can set up your account here on my web site. If you're not a member, Join Today!

Links

Continuous Forms: https://599cd.com/Continuous
KeyPress Event: https://599cd.com/KeyPress
KeyDown Event: https://599cd.com/KeyDown
Search As You Type: https://599cd.com/SearchAsYouType

Learn More FREE Access Beginner Level 1 Access Level 2 for $1.00 Free Templates Blank Customer Template Customers & Contacts Order Entry & Invoicing More Access Templates

Resources Mailing List - Get Emails When New Videos Released! Consulting - Need Help with Your Database? Questions? Please feel free to post your questions or comments below or submit them via the TechHelp page.