Openform action was canceled - Access 2007

I develop (i.e. constantly improve) an MS Access based MRP/ERP/CRM application for my employer. The company absolutely relies on the system. So if an employee can't use the database - they are seriously constrained.

The database was developed in Access 2003. When I recently bought a new system for our CAD designer, it came pre-loaded with Office 2007 (and Windows XP thanks to Dell's wise decision to not force Vista upon the world).

Anyhow, I ran into some compatibility issues between the Access 2003 and Access 2007 and thought I would document them here.

It appears that Access 2007 doesn't like OnOpen events for forms. If try to open a form that has an OnOpen event from the Switchboard (or any other form), you get an error: "The OpenForm action was canceled".

So, my work around was to change the OnOpen events to OnLoad events... Seemed to make the problem go away. I just wish I didn't have so many forms to go through and change!