Access - run code once form is opened

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

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

Make sure that, in the form design properties, the "On Open" property still says: [Event Procedure]

Cheers,