Fast Form Update. Quickly Change Records in a Continuous Form

In this video you will learn how to quickly assign values to records in a continuous form and then automatically move to the next record with the GoToRecord acNext command. Just a tiny bit of VBA is involved. I'll show you step by step. 

Santiago from Rio de Janeiro, Brazil (a Platinum Member) asks: Every day I get a list of jobs that I have to assign technicians to. There is no rhyme or reason to it, so I can't make an update query to handle the task. There's no real "criteria" for who gets it. I just look at a brief description of what the job entails and I know which tech to assign it to based on their skills, the customer, etc. I have four techs and right now it's a lot of copy and paste. I just go down the list and copy and paste, copy and paste. Can this be simplified at all? Even if I could just have a button for each of my three techs, that would make things so much easier for me. Click a button and it assigns the tech and moves to the next record.

Members

We'll add copy and paste buttons, as well as a button to copy the current value to all of the records, and to all of the records from the current position to the end of the list.

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

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!

Links

Relational Database: https://599cd.com/Relationship
Relational Combo Box: https://599cd.com/RelationalCombo
GoToControl: https://599cd.com/GoToControl
GoToRecord: https://599cd.com/GoToRecord
While Loop: https://599cd.com/While
Intro to VBA: https://599cd.com/IntroVBA

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.