Form missing in Navigation Pane (not hidden)

[Merganser]

I am making changes to an old MS Access application (originally 2003 and converted to 2007) and have an problem with one of the forms. This form was created by a user after the original mdb was created and the form can be opened, by name, in code. However, it is not visible in the Navigation Pane, cannot be searched for in the Navigation Pane, is not in the set of forms if I loop through CurrentProject.AllForms to display the form names and is not available is I try to import objects from this mdb. This is not an issue of a hidden object because I have checked "show hidden objects" in the Navigation Pane options (I even tried checking "system objects" but that, of course, didn't work either.) I tried converting the mdb to accdb but the form is still missing.

The only way to get to this form is via the application's menu code behind. I can open the form from with the menu's button and then switch to design view. In design view I can make changes but cannot save them. The save option seems to work, but if I open the form again (the same way, from menu) the changes were actually not saved.



By the way, the module for the form does show up in the VBA Object Browser! I can also save a copy of this form and the copy does show up in the Navigation Pane. If I try to rename the copy to the original name, the message "The name you entered already exists...".

Any ideas on the reason that this form is missing from the Navigation Pane?

By the way, I did go ahead and save the copy, replacing the existing object and now the form appears in the list, but I would still like to know the reason that the original form was missing from the list.

Thanks

[June7]

Only thing I can think of is a system table record got messed up.

[Xipooo]

Have you done a compact and repair?

[Merganser]

Yes, that was one of the first things that I tried.

[Xipooo]

I would try making a new Database, and then import all of your access objects into it. Your form may or may not show up.

You an also use the hidden command of "SaveToText" to save your forms as text files and re-import them with "LoadFromText".

[Merganser]

Hi, I thought of that, too, but the form was not present in the list for import. I was able to save a copy and then replace the "missing" form with the copy. The funny thing is that the module for the form was visible in the VBA objects list. Anyway, I think that the suggestion by June7 was probably what happened. It is an old mdb. I was surprised that a compact & repair did not fix the problem, however. Thanks for taking the time to respond.

[June7]

I have faced corruption that even Compact & Repair could not resolve. I have seen where the object was deleted (or so I thought) but it still appeared in the VBA editor object list even though it wasn't in the Access navigation pane. Bizarre.

[maxhugen]

I don't know if this will help at all, but you could check if the form actually exists as far as Access is concerned:

Public Function gfMisc_ListForms%()
On Error GoTo err_handler: Const cPROC$ = "gfMisc_ListForms"
Dim db As Database: Set db = CurrentDb
Dim ctr As Container, doc As Document

    Set ctr = db.Containers!Forms
    For Each doc In ctr.Documents
        Debug.Print doc.Name
    Next doc
    
    gfMisc_ListForms = True

exit_handler:
    Set db = Nothing: Set ctr = Nothing: Set doc = Nothing
    Exit Function
err_handler:
    'Call gfLog_Error(cMODULE, cPROC, err, err.Description, Erl)
    Resume exit_handler
End Function