Using Screen.PreviousControl in Microsoft Access VBA

In this Microsoft Access tutorial, I will show you how to use the Screen.PreviousControl property to efficiently adjust multiple form values with a single set of buttons.

Dennis from Burnsville, Minnesota (a Platinum Member) asks: I have a form with 15 different values on it that I have to adjust from time to time. I want to make little buttons to add or subtract from these values, but is there any way I can do it with just one set of buttons instead of having to make buttons for every text box? Maybe click on the box and then the plus or minus button?

Members

There is no extended cut, but here is the database download:

•  Database 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

Links

• Date Buttons

Recommended Courses

• Access Developer 25

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 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, Screen.PreviousControl, VBA PreviousControl property, Access VBA PreviousControl, PreviousControl in VBA, adjust form values VBA, Microsoft Access form navigation, Access add subtract buttons, ActiveControl vs PreviousControl, VBA button click events, setting focus VBA, previous control value VBA, Access developer tips, form control manipulation VBA.