Error in Form_Open doesn't allow .mdb to open , solution needed to open VBE and code

[titli]

Working on Visual Basic for MS access applications.

By mistake I have inserted a msgbox in the Form_open event of my code(xyz.mdb) in frmMain.Ofcours e wht i was trying to print was incorrect.

Now when I try to open the .mdb, i get error message number 13 , Type mismatch error , Source: Form_frmMain.Fo rm_Open .And if i click on Ok or Cancel, access closes.



I want to open the VB editor to remove that erroneous code.How can I do that?This error simpy closes access.

[Stewart Ross]

Hi titli. To disable the automatic startup options applied to an Access database hold the shift key before you select or open the database (e.g hold shift then double-click on the name of the database in an Explorer window to start it without running the startup options).

You can then display the database window (press F11 to reveal it if it is not visible), open your form in design mode and edit its On Open event code.

-Stewart

[titli]

Thanks for your reply..