Subform total on Main Form

[Guest]

Hi. I'm fairly new to Access Forms and it seems I have followed all the
instructions from previous q/a's displayed in the forum but nothing has
worked. I have a table "Traders" in which I have all traders by office with
their YTD volume and PnL. I have a form "Testing2" in which I show each
trader and their YTD volume and PnL. I have created a Subform called
"Office" in which I would like a total for the office to appear at the footer
of the main form.

So per previous posts, I have created a calculated control in the footer of
the subform which is =sum([YTD Volume]). (Although how can I tell if that is
working when it doesn't appear anywhere?)

Then on the main form (in the footer), I have created an expression of
=(Forms!Testing2![OFFICE subform1]![YTD Volume Total]).

What am I doing wrong?
I really appreciate your help.

 

[Guest]

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

HTH

 

[Guest]

Thanks for the response but that didn't work either. I'm still getting the
error message. Any other suggestions?

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

HTH

Hi. I'm fairly new to Access Forms and it seems I have followed all the
instructions from previous q/a's displayed in the forum but nothing has
worked. I have a table "Traders" in which I have all traders by office with
their YTD volume and PnL. I have a form "Testing2" in which I show each
trader and their YTD volume and PnL. I have created a Subform called
"Office" in which I would like a total for the office to appear at the footer
of the main form.

So per previous posts, I have created a calculated control in the footer of
the subform which is =sum([YTD Volume]). (Although how can I tell if that is
working when it doesn't appear anywhere?)

Then on the main form (in the footer), I have created an expression of
=(Forms!Testing2![OFFICE subform1]![YTD Volume Total]).

What am I doing wrong?
I really appreciate your help.

 

[Guest]

Ok, I got it. Thanks.
But I do have another question, in my main form, I am unable to format to
percent, currency, etc. some of my cells. When I go into the format
dropdown, it's blank. Can you help me with this one?
Thanks again.

Thanks for the response but that didn't work either. I'm still getting the
error message. Any other suggestions?

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

HTH

Hi. I'm fairly new to Access Forms and it seems I have followed all the
instructions from previous q/a's displayed in the forum but nothing has
worked. I have a table "Traders" in which I have all traders by office with
their YTD volume and PnL. I have a form "Testing2" in which I show each
trader and their YTD volume and PnL. I have created a Subform called
"Office" in which I would like a total for the office to appear at the footer
of the main form.

So per previous posts, I have created a calculated control in the footer of
the subform which is =sum([YTD Volume]). (Although how can I tell if that is
working when it doesn't appear anywhere?)

Then on the main form (in the footer), I have created an expression of
=(Forms!Testing2![OFFICE subform1]![YTD Volume Total]).

What am I doing wrong?
I really appreciate your help.

 

[Guest]

You didn't mention an error message in your first post, you just said it
wasn't working. What is the error message? Also, you mentioned that the
calculated control in your subforms footer wasn't showing up. Is it a text
box control? Is the the visible property set to yes?

Thanks for the response but that didn't work either. I'm still getting the
error message. Any other suggestions?

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

HTH

Hi. I'm fairly new to Access Forms and it seems I have followed all the
instructions from previous q/a's displayed in the forum but nothing has
worked. I have a table "Traders" in which I have all traders by office with
their YTD volume and PnL. I have a form "Testing2" in which I show each
trader and their YTD volume and PnL. I have created a Subform called
"Office" in which I would like a total for the office to appear at the footer
of the main form.

So per previous posts, I have created a calculated control in the footer of
the subform which is =sum([YTD Volume]). (Although how can I tell if that is
working when it doesn't appear anywhere?)

Then on the main form (in the footer), I have created an expression of
=(Forms!Testing2![OFFICE subform1]![YTD Volume Total]).

What am I doing wrong?
I really appreciate your help.

 

[Guest]

When the fields on you form are bound directly to a table, then the format is
determined by the data type of that field in the table. If you look at the
design view of your table you can see what data type each field is set to
(test, number, currency, etc.). You can change it, but make sure any existing
data in the table won't be corrupted before you do. If you're not sure, don't
change it!

Ok, I got it. Thanks.
But I do have another question, in my main form, I am unable to format to
percent, currency, etc. some of my cells. When I go into the format
dropdown, it's blank. Can you help me with this one?
Thanks again.

Thanks for the response but that didn't work either. I'm still getting the
error message. Any other suggestions?

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

HTH

:

Hi. I'm fairly new to Access Forms and it seems I have followed all the
instructions from previous q/a's displayed in the forum but nothing has
worked. I have a table "Traders" in which I have all traders by office with
their YTD volume and PnL. I have a form "Testing2" in which I show each
trader and their YTD volume and PnL. I have created a Subform called
"Office" in which I would like a total for the office to appear at the footer
of the main form.

So per previous posts, I have created a calculated control in the footer of
the subform which is =sum([YTD Volume]). (Although how can I tell if that is
working when it doesn't appear anywhere?)

Then on the main form (in the footer), I have created an expression of
=(Forms!Testing2![OFFICE subform1]![YTD Volume Total]).

What am I doing wrong?
I really appreciate your help.

 

[Guest]

I swear this is my last question. But in my table I have YTD Volume,
Projected 2008 Volume Rate (which the user enters in a %) and I have a column
for Projected 2008 Volume. In my form, I have a calculated control that
calculates the YTD Volume*Rate for the Projected Volume. Is there any way to
then populate the table with that volume number? I thought that if I bound
the calculation to the Projected 2008 volume column but since I have the
control calculation already in the control source, I can't do that. Any
suggestions? I told you that I'm a novice when it comes to forms.

When the fields on you form are bound directly to a table, then the format is
determined by the data type of that field in the table. If you look at the
design view of your table you can see what data type each field is set to
(test, number, currency, etc.). You can change it, but make sure any existing
data in the table won't be corrupted before you do. If you're not sure, don't
change it!

Ok, I got it. Thanks.
But I do have another question, in my main form, I am unable to format to
percent, currency, etc. some of my cells. When I go into the format
dropdown, it's blank. Can you help me with this one?
Thanks again.

Thanks for the response but that didn't work either. I'm still getting the
error message. Any other suggestions?

:

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

HTH

:

Hi. I'm fairly new to Access Forms and it seems I have followed all the
instructions from previous q/a's displayed in the forum but nothing has
worked. I have a table "Traders" in which I have all traders by office with
their YTD volume and PnL. I have a form "Testing2" in which I show each
trader and their YTD volume and PnL. I have created a Subform called
"Office" in which I would like a total for the office to appear at the footer
of the main form.

So per previous posts, I have created a calculated control in the footer of
the subform which is =sum([YTD Volume]). (Although how can I tell if that is
working when it doesn't appear anywhere?)

Then on the main form (in the footer), I have created an expression of
=(Forms!Testing2![OFFICE subform1]![YTD Volume Total]).

What am I doing wrong?
I really appreciate your help.

 

[Guest]

You should never try to store a calculated value in a table because they are
just calculations based on information that's already in the table. They just
appear on your forms, in your queries, etc.

I swear this is my last question. But in my table I have YTD Volume,
Projected 2008 Volume Rate (which the user enters in a %) and I have a column
for Projected 2008 Volume. In my form, I have a calculated control that
calculates the YTD Volume*Rate for the Projected Volume. Is there any way to
then populate the table with that volume number? I thought that if I bound
the calculation to the Projected 2008 volume column but since I have the
control calculation already in the control source, I can't do that. Any
suggestions? I told you that I'm a novice when it comes to forms.

When the fields on you form are bound directly to a table, then the format is
determined by the data type of that field in the table. If you look at the
design view of your table you can see what data type each field is set to
(test, number, currency, etc.). You can change it, but make sure any existing
data in the table won't be corrupted before you do. If you're not sure, don't
change it!

Ok, I got it. Thanks.
But I do have another question, in my main form, I am unable to format to
percent, currency, etc. some of my cells. When I go into the format
dropdown, it's blank. Can you help me with this one?
Thanks again.

:

Thanks for the response but that didn't work either. I'm still getting the
error message. Any other suggestions?

:

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

HTH

:

Hi. I'm fairly new to Access Forms and it seems I have followed all the
instructions from previous q/a's displayed in the forum but nothing has
worked. I have a table "Traders" in which I have all traders by office with
their YTD volume and PnL. I have a form "Testing2" in which I show each
trader and their YTD volume and PnL. I have created a Subform called
"Office" in which I would like a total for the office to appear at the footer
of the main form.

So per previous posts, I have created a calculated control in the footer of
the subform which is =sum([YTD Volume]). (Although how can I tell if that is
working when it doesn't appear anywhere?)

Then on the main form (in the footer), I have created an expression of
=(Forms!Testing2![OFFICE subform1]![YTD Volume Total]).

What am I doing wrong?
I really appreciate your help.