How to Run Code as Your MS Access Form Opens - On Open, On Load, and On Current

[@edwardkinney968]

I am getting a lot of good information from your videos, Thanks. Have you ever set different control properties on a form on different records? Based on your video it must use the On Current event. I can't seem to figure it out.

[@seanmackenziedataengineering]

You bet! You can use On Current as you see in this video. One way you can do it is to use If.. Then.. End If to change your control properties based on values in your fields. ie. Something like: If Me!txtPartType = "Axle" Then Me!txtAutoSet.Visible = False Me!cboAxleSize.BackColor = vbRed End If

[@henrysen-opoku1090]

Hello Sean, on a form with several combo boxes for filter; how do we load the form without its visible row before we start to filter. Thank you for your invaluable assistance.

[@seanmackenziedataengineering]

One trick is to set the DataSource of the form to something like: Select * From MyTable Where ID = 0; So, the initial load is empty but then has entries when you proceed to filter.

[@larrywelch9359]

Do you have or know of any available course that I might purchase pertaining to: MS Access, VBA Code, creating a function that will set the ActiveForm and ActiveControl (of function) that can be used on the current open form. Thanks in advance

[@seanmackenziedataengineering]

Not that I know of.. this is a good idea for a video though! Thanks!

[@jot2243]

Hi Sean. I was trying to change the form to launch my MS-Access to a particular form (In the Access option, Current Database Tab) but each time and I did that, I got this warning message "The value of a Display Form property was invalid and was not saved" and it returns the value to none even though I have done it countless times before now. It won't change even if I open it again and change it to the form I want. I need your help to resolve this issue as I am stuck. Thanks

[@seanmackenziedataengineering]

You probably need to open your database in exclusive mode. Someone (even you perhaps) may have another database lock open on the file. Open Access > Open > Browse > in the dropdown next to Open, choose Open Exclusive If you can't, you may need to ask others to close the file or restart your machine to remove the lock.

[@shafiqueahmad9024]

It's very interesting and helping

[@seanmackenziedataengineering]

Glad it was helpful!

[@weirdfun1441]

What is ON Dirty event?

[@seanmackenziedataengineering]

When you have a bound form, for example, an employee form. When you start typing into text or selecting values in bound controls, but the record has not been saved yet, the form becomes Dirty. OnDirty is an event that you can put some code in when the form becomes dirty. Somebody starts typing into a text box will trigger the event. Good idea for a video 🛠

[@Calicrazedbeats]

Nice wallpaper

[@dbdata9836]

thanks

[@seanmackenziedataengineering]

You're welcome! Glad you enjoyed it.