A dialog box pops up when I start my application

[BobC]

I did not write the application (Access 2007), but am trying to modify it.
I have a dialog box that pops up when the home form (page) of the
application opens automatically when the application begins.
The Home form is set to open automatically in the Microsoft Office
Button \Access Options \ Current Database.
The dialog box also pops up if I reopen the home form by double clicking
on it.
The dialog box says "Enter Parameter Value... OK or Cancel" and lists
"Forms!home!Text 40".
Text Box 40 is on one of the other menu pages and is used is the
expression fields of the 'criteria' in 3 of the queries.

This error began occurring after I deleted another a tab (called
'changes that was on another menu tab along with it's associated form
and table and menu tab.
I compacted & repaired the application to NO AVAIL.

I was thinking that an AUTOEXEC Macro might be the culprit; but I do not
know how to find it if there is?
Help Please?
Bob

 

[Jeanette Cunningham]

The problem is in the home form.
Access can't find any value for "Forms!home!Text 40".
Because it can't find the value of "Forms!home!Text 40",
it can't open properly. Most probably, "Forms!home!Text 40" was
on the now deleted tab.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[KenSheridan via AccessMonster.com]

Bob:

My guess would be that the name of the control is Text40 but one or more of
the references to the control incorrectly includes a space, Text 40. Another,
less likely, possibility is that the control name does include the space, but
one or more of the references does not include the name in square brackets
[Text 40], which is necessary when object names include a space or other
special character.

Ken Sheridan
Stafford, England

 

[BobC]

All I have on the Home page is a Logo and 3 Label Boxes showing
Application Name & Revision Number.
Text 40 is combo box on the 3rd Tab (Orders)used to select categories of
orders.
I am trying to delete the 5th Tab (Changes) which has a Form and a Table
assotiated only to the change function (AS FAR AS I KNOW!)

One thing that is somewhat confusing is the Logo on the Home page shows
through the 4th Tab which only has 2 Commond buttons on it.
The Labels (Application Name and Version Numbers do not show though on
other tabs?
Bob

 

[BobC]

I may have misled you!
I was in error in my initial post.
The error message does not have a space in Text40... should be:
"Forms!home!Text40"
The 3rd Tab (Orders) has a combo box Text40. I am trying to delete the
5th Tab (Changes) which (to my knowledge) only had a Table and a Form
associated with it?

Bob:

My guess would be that the name of the control is Text40 but one or more of
the references to the control incorrectly includes a space, Text 40. Another,
less likely, possibility is that the control name does include the space, but
one or more of the references does not include the name in square brackets
[Text 40], which is necessary when object names include a space or other
special character.

Ken Sheridan
Stafford, England

I did not write the application (Access 2007), but am trying to modify it.
I have a dialog box that pops up when the home form (page) of the
application opens automatically when the application begins.
The Home form is set to open automatically in the Microsoft Office
Button \Access Options \ Current Database.
The dialog box also pops up if I reopen the home form by double clicking
on it.
The dialog box says "Enter Parameter Value... OK or Cancel" and lists
"Forms!home!Text 40".
Text Box 40 is on one of the other menu pages and is used is the
expression fields of the 'criteria' in 3 of the queries.

This error began occurring after I deleted another a tab (called
'changes that was on another menu tab along with it's associated form
and table and menu tab.
I compacted& repaired the application to NO AVAIL.

I was thinking that an AUTOEXEC Macro might be the culprit; but I do not
know how to find it if there is?
Help Please?
Bob

 

[KenSheridan via AccessMonster.com]

Bob:

I assume that the Text40 control is in the parent form's Controls collection,
not in that of a subform on the page of the tab control. Assuming that to be
the case try opening the form and then referencing the control form the debug
window with:

? Forms!home!Text40.Name

If you find it cannot be referenced in this way try deleting the control and
then recreating it.

Ken Sheridan
Stafford, England

I may have misled you!
I was in error in my initial post.
The error message does not have a space in Text40... should be:
"Forms!home!Text40"
The 3rd Tab (Orders) has a combo box Text40. I am trying to delete the
5th Tab (Changes) which (to my knowledge) only had a Table and a Form
associated with it?

Bob:

[quoted text clipped - 29 lines]

 

[BobC]

Ken
The Text40 control is on a subform of a page of another Tab Control (not
the one that I want to delete.
Bob

Bob:

I assume that the Text40 control is in the parent form's Controls collection,
not in that of a subform on the page of the tab control. Assuming that to be
the case try opening the form and then referencing the control form the debug
window with:

? Forms!home!Text40.Name

If you find it cannot be referenced in this way try deleting the control and
then recreating it.

Ken Sheridan
Stafford, England

I may have misled you!
I was in error in my initial post.
The error message does not have a space in Text40... should be:
"Forms!home!Text40"
The 3rd Tab (Orders) has a combo box Text40. I am trying to delete the
5th Tab (Changes) which (to my knowledge) only had a Table and a Form
associated with it?

Bob:

[quoted text clipped - 29 lines]

Help Please?
Bob

 

[KenSheridan via AccessMonster.com]

Bob:

If its on a subform then, as a subform is not a member of the Forms
collection, you can't reference it as:

Forms!home!Text40

It has to be referenced via the Form property of the subform control in the
parent form (i.e. the control which houses the subform). The syntax is:

Forms!ParentFormName!SubformControlName.Form!Text40

Ken Sheridan
Stafford, England

Ken
The Text40 control is on a subform of a page of another Tab Control (not
the one that I want to delete.
Bob

Bob:

[quoted text clipped - 24 lines]