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.
