Access - run code once form is opened

**adgjqetuo** · 12-01-2010, 12:13 PM

Hello -

I have a section of my VBA which has stopped working and I'm hoping someone can help me troubleshoot. All other Macros and code work fine inside this database.

I have code in this section of a form:

Private Sub Form_Open(Cancel As Integer)
MsgBox ("Welcome!")

DoCmd.Maximize

End Sub

It doesn't error our, however it doesn't run either. It seems as if something was turned off where it won't recognize any code inside that section.

**alansidman** · 12-01-2010, 03:02 PM

Have you tried erasing the code. Closing the Form and saving it. Open the form and re-enter the code. Sometimes, Access does some strange things. Also before you do the above, consider running Repair and Compact.

Alan

**split_atom18** · 12-06-2010, 05:55 PM

In my experience when this happens, it is because the forms properties looses the event procedure tag.

Check the following:

Open the form in Design View
Before Clicking Anything on the form pull up the forms properties window.
Click the Event Tab
Find the "On Load" line - Select the "..." button to the right, and click "Code Builder" then click ok.
This should open the VB Window, click the save button to save your db at this point.
Close the form, reopen it and it should work again.

These Directions are based on Access 2007, however there are very similar steps in almost all versions. For whatever reason I have had this happen to me 20 times or so in the last year while doing various test runs on code in the intermediate window. Wish I knew the reason why.

Hope this helps,

Dan