#Name error

I am trying to put a total from a sub form onto another form but keep getting
the #name error message, any pointers would be most welcolm.

I have a form named test table based on query, fields quantity, unit cost
and total. In the footer of the form i have added text box which is named
total unit cost. In the control source =sum([total]). This produces me with
the correct results.

I have created another form named link form which I have added a text box
and input against the control source =([test table].Form.[total unit cost].
The only result I get is the #name when in form view.

I have set these forms, tables up as a test, as I am experiencing the same
problem on another database and hoped I could get it working on something as
straight forward as this simple database. I am quite new to access, I have
had this working on another database and cannot see what the difference is to
idenftify where I am going wrong.

#Name# is Access' way of telling you that spelling counts. Access can't
find the field and/or control the way you spelled it.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"julief" wrote in message
...
I am trying to put a total from a sub form onto another form but keep
getting
the #name error message, any pointers would be most welcolm.

I have a form named test table based on query, fields quantity, unit cost
and total. In the footer of the form i have added text box which is named
total unit cost. In the control source =sum([total]). This produces me
with
the correct results.

I have created another form named link form which I have added a text box
and input against the control source =([test table].Form.[total unit
cost].
The only result I get is the #name when in form view.

I have set these forms, tables up as a test, as I am experiencing the same
problem on another database and hoped I could get it working on something
as
straight forward as this simple database. I am quite new to access, I
have
had this working on another database and cannot see what the difference is
to
idenftify where I am going wrong.

On Wed, 6 Aug 2008 07:50:02 -0700, julief
wrote:

I am trying to put a total from a sub form onto another form but keep getting
the #name error message, any pointers would be most welcolm.

I have a form named test table based on query, fields quantity, unit cost
and total. In the footer of the form i have added text box which is named
total unit cost. In the control source =sum([total]). This produces me with
the correct results.

I have created another form named link form which I have added a text box
and input against the control source =([test table].Form.[total unit cost].
The only result I get is the #name when in form view.

I have set these forms, tables up as a test, as I am experiencing the same
problem on another database and hoped I could get it working on something as
straight forward as this simple database. I am quite new to access, I have
had this working on another database and cannot see what the difference is to
idenftify where I am going wrong.

You need to reference the Forms collection. Try this instead:

=Forms![test table]!Form.[total unit cost]

Lynn Trapp
www.ltcomputerdesigns.com

I have tried your suggestion and it still produces the same result. I have
checked all the spellings and they are correct.

"julief" wrote:

I am trying to put a total from a sub form onto another form but keep getting
the #name error message, any pointers would be most welcolm.

I have a form named test table based on query, fields quantity, unit cost
and total. In the footer of the form i have added text box which is named
total unit cost. In the control source =sum([total]). This produces me with
the correct results.

I have created another form named link form which I have added a text box
and input against the control source =([test table].Form.[total unit cost].
The only result I get is the #name when in form view.

I have set these forms, tables up as a test, as I am experiencing the same
problem on another database and hoped I could get it working on something as
straight forward as this simple database. I am quite new to access, I have
had this working on another database and cannot see what the difference is to
idenftify where I am going wrong.

I've only run across that when Access can't figure out what you're telling
it to use. Can you open that form in design view, open the properties
window for that control, and pick the correct field from the listed fields?
And if that doesn't work, what happens if you pick one of the other fields
(incorrect, I know, but if you can see it displayed in the form, that tells
us something...)

Regards

Jeff Boyce
Microsoft Office/Access MVP


"julief" wrote in message
...
I have tried your suggestion and it still produces the same result. I have
checked all the spellings and they are correct.

"julief" wrote:

I am trying to put a total from a sub form onto another form but keep
getting
the #name error message, any pointers would be most welcolm.

I have a form named test table based on query, fields quantity, unit cost
and total. In the footer of the form i have added text box which is
named
total unit cost. In the control source =sum([total]). This produces me
with
the correct results.

I have created another form named link form which I have added a text box
and input against the control source =([test table].Form.[total unit
cost].
The only result I get is the #name when in form view.

I have set these forms, tables up as a test, as I am experiencing the
same
problem on another database and hoped I could get it working on something
as
straight forward as this simple database. I am quite new to access, I
have
had this working on another database and cannot see what the difference
is to
idenftify where I am going wrong.

I can see the control, if I pick it up I still get the #Name error, if i try
to pick something else up I get the #Error message.

"Jeff Boyce" wrote:

I've only run across that when Access can't figure out what you're telling
it to use. Can you open that form in design view, open the properties
window for that control, and pick the correct field from the listed fields?
And if that doesn't work, what happens if you pick one of the other fields
(incorrect, I know, but if you can see it displayed in the form, that tells
us something...)

Regards

Jeff Boyce
Microsoft Office/Access MVP


"julief" wrote in message
...
I have tried your suggestion and it still produces the same result. I have
checked all the spellings and they are correct.

"julief" wrote:

I am trying to put a total from a sub form onto another form but keep
getting
the #name error message, any pointers would be most welcolm.

I have a form named test table based on query, fields quantity, unit cost
and total. In the footer of the form i have added text box which is
named
total unit cost. In the control source =sum([total]). This produces me
with
the correct results.

I have created another form named link form which I have added a text box
and input against the control source =([test table].Form.[total unit
cost].
The only result I get is the #name when in form view.

I have set these forms, tables up as a test, as I am experiencing the
same
problem on another database and hoped I could get it working on something
as
straight forward as this simple database. I am quite new to access, I
have
had this working on another database and cannot see what the difference
is to
idenftify where I am going wrong.

Is your form "bound" to a query or a table?

If it is, and if it is the correct query/table, my next step, if this were
mine, would be to start over building a new form from scratch.

Or maybe one of the other newsgroup readers can offer a different
perspective...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP



"julief" wrote in message
...
I can see the control, if I pick it up I still get the #Name error, if i
try
to pick something else up I get the #Error message.

"Jeff Boyce" wrote:

I've only run across that when Access can't figure out what you're
telling
it to use. Can you open that form in design view, open the properties
window for that control, and pick the correct field from the listed
fields?
And if that doesn't work, what happens if you pick one of the other
fields
(incorrect, I know, but if you can see it displayed in the form, that
tells
us something...)

Regards

Jeff Boyce
Microsoft Office/Access MVP


"julief" wrote in message
...
I have tried your suggestion and it still produces the same result. I
have
checked all the spellings and they are correct.

"julief" wrote:

I am trying to put a total from a sub form onto another form but keep
getting
the #name error message, any pointers would be most welcolm.

I have a form named test table based on query, fields quantity, unit
cost
and total. In the footer of the form i have added text box which is
named
total unit cost. In the control source =sum([total]). This produces
me
with
the correct results.

I have created another form named link form which I have added a text
box
and input against the control source =([test table].Form.[total unit
cost].
The only result I get is the #name when in form view.

I have set these forms, tables up as a test, as I am experiencing the
same
problem on another database and hoped I could get it working on
something
as
straight forward as this simple database. I am quite new to access, I
have
had this working on another database and cannot see what the
difference
is to
idenftify where I am going wrong.