Question Error message, need help solving

[pholt33]

When I open a database I get the error message "The expression On Load you entered as the event property setting produced the following error: Argument not optional."

This error occurs only on my computer but not on anyone else's in the office when opening the same database, so I suspect it is a setting of some sort. I have looked at the References within VBA and they match what is on other peoples' machines.

Where should I look to fix this error? :banghead:

Thanks!

 

[James Dudden]

Are you using Access 2010?
I have seen this error randomly occur in several databases and it normally goes away if I open the form in design view and then close the form and then dbl-click to open the form from the side bar. Or just do a compact. Something like that....

I haven't figured out an exact pattern yet on why it happens and what fixes it though!!

 

[James Dudden]

...also, this may be a genuine error so I would recommend compiling your database from the VBA window.

 

[pholt33]

I think I figured out the problem.

VBA --> Tool --> Options --> General --> Compile

The "Compile on Demand" boxes were unchecked. Once I checked those, the database opened normally and without any problem!