how to get to other records of continuous subform

[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

 

[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

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]

 

[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

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

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]