accessing datafield in subform

[drd1]

How do I access multiple records in a subform? I can get to the first record using [subformname].[fieldname] but I cannot move to the next record.Im trying to acces the information in one field. the subform was built on a query the field Im trying to access is a calculation. the value from this calculation must be used to create another calculation (in vba) the result of this will be display in the main form.

 

[SimonC]

One way might be to create an invisible text box in the header or footer of the subform and let this hold the sum of all the instances of the same field in the subform.

Then you can reference this single field from the main form.

Simon.