Subform Calculations

[cel504]

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.

 

[cel504]

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]

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.
http://www.mvps.org/access/forms/frm0031.htm

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

 

[cel504]

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.

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.

 

[cel504]

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.

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.

 

[cel504]

Thanks for that and I undestand what you are saying.

Cel.

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.

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