Subform Calculations

Could anyone tell me, is it possible do a summary calculation of a subform
and show the results on the main form. If I have a form and there is a
subform displayed on it. One of the fields on the subform, is say a job cost,
as the additional records are entered on the subform, the cost is calculated
and displayed in a text box on the main form.

Any ideas, on if this is possible. Many thanks.

You can put an invisible TextBox in the Footer of the SubForm named txtTotal
and set the ControlSource of this TextBox to =Sum([job cost])

Then you can have a TextBox on the MainForm with the ControlSource set to:
YourSubFormControlName.FORM.txtTotal
...using your sub form control name of course.

cel504 wrote:
Could anyone tell me, is it possible do a summary calculation of a subform
and show the results on the main form. If I have a form and there is a
subform displayed on it. One of the fields on the subform, is say a job cost,
as the additional records are entered on the subform, the cost is calculated
and displayed in a text box on the main form.

Any ideas, on if this is possible. Many thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

Many thanks for your quick reponse and I understand what you are saying, will
this work if the subform is in a datasheet view? I have tried doing what you
suggested and it displays and error message.

Any further ideas, but I will keep trying.




"cel504" wrote:

Could anyone tell me, is it possible do a summary calculation of a subform
and show the results on the main form. If I have a form and there is a
subform displayed on it. One of the fields on the subform, is say a job cost,
as the additional records are entered on the subform, the cost is calculated
and displayed in a text box on the main form.

Any ideas, on if this is possible. Many thanks.

It should work just fine in Datasheet mode. Perhaps your reference to the
control syntax is not correct.
http://www.mvps.org/access/forms/frm0031.htm

cel504 wrote:
Many thanks for your quick reponse and I understand what you are saying, will
this work if the subform is in a datasheet view? I have tried doing what you
suggested and it displays and error message.

Any further ideas, but I will keep trying.

Could anyone tell me, is it possible do a summary calculation of a subform
and show the results on the main form. If I have a form and there is a
[quoted text clipped - 3 lines]

Any ideas, on if this is possible. Many thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

Once again many thanks for that and I will go over the it again and check it
out.



"ruralguy via AccessMonster.com" wrote:

It should work just fine in Datasheet mode. Perhaps your reference to the
control syntax is not correct.
http://www.mvps.org/access/forms/frm0031.htm

cel504 wrote:
Many thanks for your quick reponse and I understand what you are saying, will
this work if the subform is in a datasheet view? I have tried doing what you
suggested and it displays and error message.

Any further ideas, but I will keep trying.

Could anyone tell me, is it possible do a summary calculation of a subform
and show the results on the main form. If I have a form and there is a
[quoted text clipped - 3 lines]

Any ideas, on if this is possible. Many thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

Post back if you are still having problems.

cel504 wrote:
Once again many thanks for that and I will go over the it again and check it
out.

It should work just fine in Datasheet mode. Perhaps your reference to the
control syntax is not correct.
[quoted text clipped - 11 lines]

Any ideas, on if this is possible. Many thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

It worked treat many thanks for you help. I am not sure if this is possible
or not, but if you enter data in a subform say, 2 items at £2.50 each can you
get it to calculate £5.00 as you enter it. I know you would normally do this
in a query, but just interested to see if is possible, that's all.

Once again, thanks for you help and time taken.

Cel

"ruralguy via AccessMonster.com" wrote:

Post back if you are still having problems.

cel504 wrote:
Once again many thanks for that and I will go over the it again and check it
out.

It should work just fine in Datasheet mode. Perhaps your reference to the
control syntax is not correct.
[quoted text clipped - 11 lines]

Any ideas, on if this is possible. Many thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

You can cause the calculating control to recalc in the AfterUpdate event of
the other control.

cel504 wrote:
It worked treat many thanks for you help. I am not sure if this is possible
or not, but if you enter data in a subform say, 2 items at £2.50 each can you
get it to calculate £5.00 as you enter it. I know you would normally do this
in a query, but just interested to see if is possible, that's all.

Once again, thanks for you help and time taken.

Cel

Post back if you are still having problems.

[quoted text clipped - 6 lines]

Any ideas, on if this is possible. Many thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

I think I may have confused you a little, what I was trying to get my head
around was,if it is possible to have an extra column on the subform table and
as you completed say columm one with a number, column two with a rate and the
third column would display the calculation of the first two colums. I have
done this is a query, but only interested if it was possible in a table.

Many thanks, Cel.

"ruralguy via AccessMonster.com" wrote:

You can cause the calculating control to recalc in the AfterUpdate event of
the other control.

cel504 wrote:
It worked treat many thanks for you help. I am not sure if this is possible
or not, but if you enter data in a subform say, 2 items at £2.50 each can you
get it to calculate £5.00 as you enter it. I know you would normally do this
in a query, but just interested to see if is possible, that's all.

Once again, thanks for you help and time taken.

Cel

Post back if you are still having problems.

[quoted text clipped - 6 lines]

Any ideas, on if this is possible. Many thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

It is a calculated value and therefore should not be in a table. There are
no triggers in Access so there is nothing in the table to keep that field
accurate.

cel504 wrote:
I think I may have confused you a little, what I was trying to get my head
around was,if it is possible to have an extra column on the subform table and
as you completed say columm one with a number, column two with a rate and the
third column would display the calculation of the first two colums. I have
done this is a query, but only interested if it was possible in a table.

Many thanks, Cel.

You can cause the calculating control to recalc in the AfterUpdate event of
the other control.
[quoted text clipped - 13 lines]

Any ideas, on if this is possible. Many thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1