Request a specific record value from a continuous form field

[kuipers78]

I've created a continuous form with a field called "Age" in the detail section of the form. The continuous form displays the records of a table called "Children", which contains 5 records.
I want to request the age of all children (seperated) from the fields in the form, but when I refer to 'Me.Age' in VBA, I only get the age of the first record. How can I request, for example, the second record field value in my form while the code is placed under the Footer section (this is a requirement) of the form? Or isn't this possible?

 

[ajetrumpet]

Yes it is possible, as anything is. your desc. is vague. maybe an upload of the DB would help someone else help you out. I'm sure they could!

 

[kuipers78]

I figured it out myself. The records of a continuous form can be requested by using the 'Me.Recordset' command. So, if I want to know the value of the second record I can simply put in my VBA: "Me.Recordset.Movenext"
That's all...