how to get to other records of continuous subform

M

MattE

Please help this novice get this figured out.

I have a form and in it is a subform which is continuous. In the
subform, in a text field called Price which will actually have numeric
content, in the AfterUpdate event, I need to total the contents of all
the Price's. I'm having trouble 1) knowing how many records there are,
and then 2) totaling the Price fields.

I'd have to go through Me's Parent, right?

Thanks,
Matt
 
J

John Vinson

Please help this novice get this figured out.

I have a form and in it is a subform which is continuous. In the
subform, in a text field called Price which will actually have numeric
content, in the AfterUpdate event, I need to total the contents of all
the Price's. I'm having trouble 1) knowing how many records there are,
and then 2) totaling the Price fields.

I'd have to go through Me's Parent, right?

Thanks,
Matt
Click to expand...

Nope.

Make the Subform's Footer visible (with the View menu option in form
design).

On the Footer put a textbox with a Control Source

=Sum(CCur([Price]))

Why are you storing a numeric price in a Text datatype field???

John W. Vinson[MVP]
 
M

MattE

Thanks! I managed to figure the same thing out just before reading
your answer. Actually it's a TextBox with a numeric value (this is in
the subform, not in the table).
Matt

John said:
Please help this novice get this figured out.

I have a form and in it is a subform which is continuous. In the
subform, in a text field called Price which will actually have numeric
content, in the AfterUpdate event, I need to total the contents of all
the Price's. I'm having trouble 1) knowing how many records there are,
and then 2) totaling the Price fields.

I'd have to go through Me's Parent, right?

Thanks,
Matt
Click to expand...

Nope.

Make the Subform's Footer visible (with the View menu option in form
design).

On the Footer put a textbox with a Control Source

=Sum(CCur([Price]))

Why are you storing a numeric price in a Text datatype field???

John W. Vinson[MVP]
Click to expand...
 
Top