Error message about form doesn't exist but form not referenced??

[Emjaysea]

Whenever I open the database I get a message that "The form name xxxx is
misspelled or refers to a form that doesn't exist." The referenced form has
been deleted and there is no longer any reference to this form in my
database. I want to make this message stop appearing. Any ideas? Thanks.

 

[SteveM]

Check what is set as your startup form. If it is different, check the code in
that form for references to the deleted form.

You may also want to look for an Autoexec macro.

Steve

 

['69 Camaro]

Hi.

Whenever I open the database I get a message that "The form name xxxx is
misspelled or refers to a form that doesn't exist." The referenced form
has
been deleted and there is no longer any reference to this form in my
database.

There's at least one reference to the form in your database. Otherwise you
wouldn't be getting that error message. Since it happens when you open the
database, check the startup dialog window and see if the startup "Display
Form/Page" combo box doesn't list the name of the deleted form. If you have
an AutoExec macro, check that for the name of the deleted form within its
macro actions.

If you don't see the form's name in either place, then check your startup
form's properties for the name of the deleted form (presumably you've
already searched the VBA code for the name of the deleted form, so no need
to search the modules again). If you still can't find it, check any queries
that the startup form uses to see whether or not there's a query depending
upon something like "Forms!DeletedFormName!txtBoxName."

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Emjaysea]

Thanks - it was the startup form and is now solved. Thanks very much.