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

[@nickbroekhuizen8858]

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

[@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!

[@saeedazhdar2429]

Thanks 🙏🌹 Saeed from iran🌹

[@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?

[@suat55kucuk61]

Thanks very much sir

[@599CD]

Most welcome