Can't get in to design view - help!

[peted]

I've got a bit of a problem with my database. For reasons I won't go into I set the unload event of my main menu form to "Cancel = True". I thought that's what I wanted to get round a problem I had, but it turns out it isn't. Anyway, I now can't change that Unload event as this form no longer allows me to access its design view. Is that related to the unload event? And if so, how can I get back into design view to alter it?

 

[KenHigg]

Not sure whats going on - Where are you setting the Cancel=True?

 

[peted]

I just typed it into the On Unload line of the prooperty sheet for that form.

 

[KenHigg]

You should be getting an error like 'Can't find macro' - ??

Can you make a copy of the form and open it in design view?

 

[peted]

I'm not getting that error message. I can make a copy of the form, but I can't open that in design view either.

 

[KenHigg]

Copy it to a new .mdb and post it, I'll see if I can figure it out.

 

[peted]

Cheers, Ken. Here it is, although it's not .mdb as it's Access 2007. The data is just test data, not real patient info! I noticed when using explorer that there's an associated Access Record-Locking information file. Would that be anything to do with the problem?

 

[KenHigg]

I guess that takes me out of the picture, I don't have 2007. Sorry. Maybe someone else can jump in...

 

[peted]

Thanks, for volunteering, Ken. I can't even save it as a .mdb for you to have a look at, because in order to do that Access needs to close all open objects, which it can't because of this blasted code in the On Unload event. So, is there anyone else out there who thinks they know what the problem is? if not, I guess I'll have to start from scratch again.