Form Footer Problems

[Benn]

Hi guys,

Just a quick question and I'm sure it's something basic.

I am trying to use the Sum function on a subform. I have done a search and found the answer to my first question, however I'm still having trouble.

I have made a text box in the Form Footer of the sub-form. It contains

=Sum([FieldName])

The expression is correct but It will not show up anywhere on my form.

Thanks.

Benn.

 

[ansentry]

Have a look at my sample I posted Here

 

[Benn]

Thank you John, that really helped.

I have now got the Sum or total displayed in a text box on the main form. However, the new "Total" column still remains even after Visible:No ???

Thanks fro the help.

Benn.

 

[ansentry]

Which one is gving you the "Visible = No" problem, the "Total" on the subform or the main form?

 

[Benn]

It's the total on the main form. It just adds the extra column and displays the total on each row.
----------------
Field1------Total
1_________11
3_________11
5_________11
2_________11

Like that in the main form. I just want to hide it.

 

[ansentry]

Is the main form a single form or a continious form?

 

[Benn]

I think it's a single form.

I used the Wizard to add one field from one table (main form) and other fields from other tables to create the subform.

 

[ansentry]

If you have a look at my sample, you will see that both of the controls that do the summing are unbound; these are the one on the subform and the one on the main form. You do not (in this case) store the value of either in tables.

Post a copy of you db and I (or someone else) will have a look, just remove any data that you don't want people to see.

 

[Benn]

Thanks ansentry.

I'm not quite sure what was happening. I started over again and everything worked fine, I must have made a small mistake somewhere.

I also have another question regarding the value I created I the total box. I have tried using a setvalue macro with the following expressions -

Item:[Tablecontainingfield]![FieldIwanttochange]
Expression: [Forms]![nameofform]![nameoftextboxcontainingvalue]

Is there a different way to do this?

Thanks again for the help with the footer, if you don't know the answer to the other question I'll make a new topic.

 

[ansentry]

I also have another question regarding the value I created I the total box. I have tried using a setvalue macro with the following expressions

Sorry I have not idea what you are trying to do, maybe you should start another thread.