Form won't open after I added a subform to it 1

[ajaeger]

I have a form (frmSponsorship) that had two subforms on it and was working fine. I created a new table and form (frmPromotions) and added that to frmSponsorship. I set-up the parent and child fields to link the form and subform. Now I can't open the form in Design view or Form View. The error that I'm getting is:

Run-time error '2001':
You canceled the previous operation.

End/Debug/Help

When I click Debug, it takes me to the code that I used on a previous form (frmMainMenu) to open frmSponsorship:

stDocName = "frmSponsorship"
DoCmd.OpenForm stDocName, , , stLinkCriteria

(the DoCmd line is highlighted in yellow)

Any suggestions on how to get into this form - ideally, I'd like to get the subform to work on this form, but at the very least I need to get into it to delete the subform so it can at least be opened and used by users.

Thanks.

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com

 

[smedvid]

Just some quick thoughts...

Could your MDB be corrupt? Try Compact/Repair; and if that fails try to import objects into a brand new MDB file.

Also, if you can get to the code; see if there are any logic/syntax problems. Perhaps try to delete the Child form and start over...

Also, hopefully you are doing some ad-hoc version control and can revert back to the previous version of the MDB as a last resort...

Good Luck... htwh,

Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[ajaeger]

I wasn't able to import frmSponsorship into a new mdb. The message was something like 'object cannot be found.' I was able to delete the form and import it from an older backup (form design was the same, but data was old). That worked, but I do think there may be some database corruption so I'll give that a try too. Thanks.

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com