How to Use the Screen.PreviousControl Property 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?
BECOME A MEMBER:
KZread: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
PreviousControl: 599cd.com/PreviousControl
PREREQUISITES:
Intro to VBA: 599cd.com/VBA
LINKS:
Date Buttons: 599cd.com/DateButtons
RECOMMENDED COURSES:
Access Developer 25: 599cd.com/ACD25
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database,, 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.
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Пікірлер: 5
Great video, Richard! I've used the ActiveControl, but I didn't know about PreviousControl! Now I know!!! Glad your feeling better. Enjoy the chicken soup! 🖖
Hey Richard! Cool video. I noticed that you always use messagebox to display values instead of using the immediate window. Also I could not find a video of yours about the immediate window. Maybe that could be a good topic for a techhelp video?
Interesting topic today. Thank you. Have you ever covered the following situation: (Example:) Record 1 has a date and time, on record 2 (and going forward) I want to have elaspsed time (days, hrs, min) from the timestamp on the previous record. Thanks.
Useful and well explained
Speeey recovery