Add Button to Access Form for Previous Record

In this Microsoft Access tutorial, I will show you how to add a button to a form to easily reopen the previous record. Ideal for switching between records like customers or orders, the tutorial covers using VBA, temp vars, and events with minimal code.

Members

In the extended cut, I will show you how to create a list of previously opened customers in order, making it easy to double-click and open any customer from this list. This feature allows for quick navigation between records with a simple requery to refresh the list.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA
• If Then
• TempVars
• Null
• Open Form
• On Current Event
• Caption
• Concatenation

Links

• Favorite Customers

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Add button Access form reopen previous record, VBA programming Access forms, Access form navigation, TempVars Access, form open specific record, Access form events, on current event Access, Access form caption property, record switching Access, Access form load event, Access button visibility toggle