--Column Sums Not totaling--

[Guest]

Ok so far the suggestion given to my question did not work. Let me specificly
draw out what I am doing.

I have a subform called Child65 or some default name. In that sub form I
have two fields:

DeductName | DeductAmou

Then at the bottom in the footer i have:

txtSubfrmTotal with a control source of: =Sum([DeductAmou])

in the main form I have a field Deduct Total that has a control source like
this:

=[forms].[child65]![deductions].[forms]![txtsubfrmtotal]

I know its wrong, but ive played around with it and all I seem to get is
#Name?

please advise.

 

[Arvin Meyer [MVP]]

The syntax is:

=[forms]![MainformName]![child65].form![txtsubfrmtotal]

Subsititute your main form name, change the bang to a dot and visa-versa
(although some of yours will work), the second "forms" should be "form" And
make absolutely sure that everything is spelled correctly.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access