How to Use a Select Case Statement as an Alternative to If Then in Microsoft Access VBA

In this Microsoft Access tutorial I'm going to teach you how to use a Select Case statement as an alternative to an If Then statement in your VBA programming.
BECOME A MEMBER:
UA-cam: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Sele...
PREREQUISITES:
Intro to VBA: 599cd.com/VBA
If Then: 599cd.com/IfThen
LINKS:
Status Box: 599cd.com/Status
Microsoft Select Case Page: tinyurl.com/2d...
RECOMMENDED COURSES:
Access Developer 2: 599cd.com/ACD02
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$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/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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, select case statement, vba select case, case statement, select case ms access
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@nickbroekhuizen8858]

I use Select Case a lot, especially with my newfound tempvars ... :) Thanks Richard.

[@saeedazhdar2429]

Thanks 🙏🌹
Saeed from iran🌹

[@Shadow.Dragon]

I always use the "Select Case" statement if I have more than 2 conditions I'm testing for. The "ElseIf" statement always confuses me; whereas, the "Select Case" seems more straight forward. Are there any pros/cons over using one over the other? Great video Richard! Have an "Excellent" weekend!

[@suat55kucuk61]

Thanks very much sir

[@599CD]

Most welcome

[@mhmadkhalife9097]

Hello sir i have a question i need to ask you i have a database that is working fine on my server
My server had an incredible virus so i took my database and my work files and i put a server on my new ssd and add the database now the database is working and the issue is that access taking so much to load and calculate things ... Instead all office programs working fine
I tried compact and repair same problem any ideas?

[@mhmadkhalife9097]

Sir any help any suggestions?
I'm thinking of building the same database on another database would it help?