Fast Form Update Quickly Change Records to Assign Jobs to Technicians in Microsoft Access GoToRecord

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.
LEVEL: Developer (A little VBA)
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.
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video. 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.
MEMBERS ONLY VIDEO:
• Fast Form Update Quick...
BECOME A MEMBER:
/ @599cd
LINKS:
Relational Database: 599cd.com/Rela...
Relational Combo Box: 599cd.com/Rela...
GoToControl: 599cd.com/GoTo...
GoToRecord: 599cd.com/GoTo...
While Loop: 599cd.com/While
Intro to VBA: 599cd.com/Intr...
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
FREE Access Beginner Level 1: 599cd.com/Free1
FREE Blank Customer Template: 599cd.com/FRL2
$1 Access Level 2: 599cd.com/1Dollar
TechHelp: 599cd.com/Tech...
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
Email Me: [e-mail]
WHAT DOES LEVEL MEAN:
My Access classes are divided into multiple levels. BEGINNER requires little working knowledge of Access. EXPERT assumes you know relationships and how to use functions. ADVANCED users know macros and events. DEVELOPER uses SQL and/or VBA programming.
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, update records, quick update, fast update, GoToRecord, acNext, jobs, technicians, sales reps, copy, paste, gotofirst, while loop
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@Jojosmith342]

We live well and absolutely prosper each day thanks to Richard's most valuable tutorials. Never forget to thumbs up even before the class starts

[@NimishP]

You are wizard. Your creativity knows no bounds.

[@599CD]

I appreciate the compliment. Now roll a Saving Throw vs. Fireballs. +2.

[@gregorywwallace]

Consider instead of command buttons linking the tech field to a frame/option group with toggle buttons. One button represents each of the techs. That way the user can easily see if the job has already been assigned. Perhaps the on click property includes code advancing to the next record. This ranks low on the relational database guidelines metrics, but high on the user interface score.

[@599CD]

Whatever works for ya

[@homeheart1276]

Once again, a most excellent and useful video! Thank you, thank you, thank you. After reading what the OP wrote to Richard...seems to me that this should be able to be automated? Maybe try writing down the criteria (skillsets) you use when assigning the tasks and then create a form for how these tasks are created? Seems like you should be able to alleviate yourself of this chore. I'm a noob though so I'm more curious as to what others think... Thanks again Richard!

[@599CD]

A most excellent comment. Party on, dude.

[@paulyang8987]

I love watching your stuffs here. may I ask, do you have a the same method or video that do the same combo box assigned task to multiple techs in the same time?

[@599CD]

I don't understand what you mean. Please clarify. Feel free to submit your question at 599cd.com/TH

[@paulyang8987]

I was asking, how to assign task to multiple users. I have an database that I can assign tasks to any 1 user in the combo box and I like to know how to code or design the same combo that can assign the task to multiple users in MS access. Thanks you in advance

[@599CD]

The PROPER way to do it would be with a 2nd related table and a one-to-many relationship with a subform. 599cd.com/subform

[@synergybydesign6783]

do you have a video on using vba to insert at field from a list of fields to create a form letter as a report?

[@599CD]

I'm sorry, I don't quite understand what you're looking for, but you can submit your questions for future videos here: 599cd.com/TechHelp

[@kumratvalleyofficial]

AOA Sir Let i have tow table "A" and other table "B" and i want to copy some selected data from table "A" to table "B".. what type of code requred to copy from table "A" to table "B". i need this in from view

[@599CD]

Feel free to submit your question here: 599cd.com/TechHelp

[@ihatemyself1659]

Hi please can you help me my subform returns wrong information and I don’t know how to fix it pls do a video on this

[@599CD]

That's like saying "my car won't start. What's wrong with it?" Without being able to look under the hood of your car, I have no idea. If you need help with your database, see 599cd.com/SendingMeFiles