Run-time Error '424: Object Required

Question

I originally built a program in Office 2003 that worked flawlessly for several years, but it would not run in Office 2010. After many unsuccessful attempts to the reolve this issue using this forum I gave up and rebuilt the entire program in Office 2010 using my original code.  I'm hoping I can get it to work again without too many problems, but I do have this issue.

I have a form with a command button to close one form and open another form with the following code:

    frmAdmin.Hide

    frmDonorShiftSummary.Show

I have several other forms ahead of this one.  They all open and close using similar code but this one doesn't.  Is this code wrong or could there be a problem with some of the code in frmShiftSummary that doesn't allow it to open?

Any suggestions would be greatly appreciated.

Thanks

Doug

Answer 1

You can make a copy of the database, strip away everything that isn't relevant to the problem, as well as all sensitive information, then zip this copy and make it available through one of the websites that let you upload and share a file, such as Windows Live SkyDrive (https://skydrive.live.com) or DropBox (http://www.dropbox.com). Post a link to the uploaded file in a reply here.

Or register at www.eileenslounge.com (it's free) and post a message in the Access forum. You can attach files up to 250 KB to a post there.

Answer 2

My mistake, it was a typing error when I typed the post.  The correct form name is frmDonorShiftSummary.  To make sure I had the form name right, I even copied it from the properties window to the code to double check. 

I have about 400 lines of code with this form.  Can I paste that much on a post?  Would it be better to email the file?

Thanks

Doug

Answer 3

Or make sure the name of the form when used with the .Show statement is correct since it's been presented using different names in the request for help.

Answer 4

Can you post the code behind frmDonorShiftSummary (or is it frmShiftSummary)?