Method 'Item' fo object 'Forms' Failed

Posted on 2006-04-27
Last Modified: 2011-09-20
A2000  XP Home Edition

I did a search and replace to change the name of a control.

I now get the message

Error -2146500594
SS Open Form Error "The name of the form"  and
Method 'Item' of object 'Forms' failed.

I can open the form in Design view, but I can't find anything that was misnamed.

What can cause this error and how do I find it?


Question by:katzwhite
    LVL 58

    Accepted Solution


    Little chance, but you might try this: change the Record Source, even just adding a dummy space. This will force the form to recreate it's internal list of objects. For example, if you have a *field* called Foo and a *control* called Foo, renaming the control drops also the field from the list. After resetting the record source, you will have both Form.Foo and Form.cboFoo for example.

    Search and replace is a tricky thing. If you did that while the form was open, for example, you might have desynchronized VB's compilation state flags.

    For serious form corruptions, the  best is to remove it entirely:

    * In the immediate pane:
       SaveAsText acForm, "frmBroken", "C:\frmBroken.txt"
    * Delete the form
    * Repair and compace
    * Recompile project
    * Back to the immediate pane:
       LoadFromText acForm, "frmBroken", "C:\frmBroken.txt"
    * Recompile project

    See if that helps.

    Author Comment


    You're wonderful.  I backup often, but had about 8 hours very intense querry work, so I didn't want to go back to the old backup, nor did I want to delete the form and reload from backup as I was afraid I wouldn't remember all the changes to it either.

    It'll take awhile to put the form back, as I changed or commented many things looking for the porblem, but I can fix all that now that the form works.

    Thanks again,

    LVL 58

    Expert Comment

    Thank you for your kind words! I'm happy that this saved your 8hrs of work.
    Good luck now!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now