Access 2007 error opening database

[sahmiele]

I am having an issue opening an old database somebody else created, and I can't figure out the problem I am using access 2007, and when I open my database immediately I get the error message:
An error occurred while loading 'Form_MAIN SCREEN'. Do you want to continue loading the project?

I believe that Form_MAIN SCREEN is a switchboard. Oddly enough, when the navigation window comes up, the form is actually named MAIN SCREEN, not Form_MAIN SCREEN. When I try to open MAIN SCREEN, I get the following error:

The expression On Open you entered as the event property setting produced the following error: Invalid procedure call or argument.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.


I can view MAIN SCREEN in design mode, but can not view any of the procedures for it. Can somebody help with this? I am at a loss. Thanks

 

[RuralGuy]

Have you tried looking at the Form's class module through the project window?

http://www.btabdevelopment.com/main...codewoutopeningtheform/tabid/111/Default.aspx

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[valgore]

yeah. go to the Database Tools tab in Access and click the Visual Basic button. make sure that the procedure isn't calling a variable that isnt there. If you call a variable that doesn't exist you get that error i believe. To answer

"I believe that Form_MAIN SCREEN is a switchboard. Oddly enough, when the navigation window comes up, the form is actually named MAIN SCREEN, not Form_MAIN SCREEN."

that is actually a form. the Form_MAIN SCREEN is just how Access 2007 labels the forms.

hope this help
Valgore