Using Option Groups in Microsoft Access: Procedure Tracking

In this Microsoft Access tutorial, you will learn about using an option group. Option groups have many uses, including selecting an option from a list. In today's example, we're going to use it to track which step we're on in a series of procedures for a medical patient.
Emily from Southaven, Mississippi (a Platinum Member) asks: I have a series of forms and procedures that need to be performed for each of my patients, in order. How can I keep track of the current step I'm on? Right now, I use a notes field but it isn't very efficient, especially when I might not see the patient for weeks and need to figure out where I left off. Is there a way to have some sort of indicator or system that will automatically help me keep track of where we're at?
Silver Members & up get access to an Extended Cut of this video. Members will learn how to automatically set the option group value when the button is clicked. We'll use just a little bit of VBA code.
MEMBERS-ONLY EXTENDED CUT VIDEO:
• Using Option Groups ME...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
Option Group: 599cd.com/OptionGroup
PREREQUISITES:
Access Beginner 1: 599cd.com/ACB1
Blank Template: 599cd.com/Blank
RECOMMENDED COURSES:
Access Expert 4: 599cd.com/ACX4
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:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, option group, track progress, procedure tracking, option buttons, shipping method, option group wizard, default choice, store value, option group appearance, option group captions, step tracking, step number field, option button copying, option value, option group formatting, option group border, step tracking example, Microsoft Access tutorial
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@user-zg1nn1nw1x]

I Richard that was a very cool video🎉 not been watching your video my wife was rushed into hospital with a blood clot in her leg good job she is retired nurse of 43 years of service this is what safer her life another great video all best Steve b

[@Shadow.Dragon]

Richard, thanks for the video!

[@xavierbatlle1828]

I usually use the value 0 for 'non defined' or 'unknown' values and I change the color of the option selected.

[@alializadeh8195]

Thanks

[@stugryffin3619]

Hey Richard, had a random thought today that it would be great for you to do something that touches on how computing power is used for access databases in a network environment. Obviously on a local system the machine cpu will do all the grunt work but what about on a network where the back end is located on a server and front end resides on local user machine? What happens locally? What happens on the server? What should users and devs consider? I thought this would be quite interesting to hear you talk about this.

[@Huskyzeit]

Please do not spoil valuable time in video with topic 'Using Option Groups in Microsoft Access' to show how to format elements in the form - that is clearly offtopic and basic knowledge, so it belongs into a different video! However it would have been nice to show how to use the value from the Option group - I searched it in the label instead of the group-frame....