Referencing fields in a continuous form ??

[ksor]

I use MS Office 365 Home version and I need to reference a date field in a continous sub form of some persons each with a birthdates in a column of the continous form.



In the immidiate windows I can get the FIRST (a row) of these birthdates with this:

"PERSON Vedligehold af" is the name of the main form,
and
"Sub Form BØRN til en forælder" is the name of the sub form on a TAB

? Forms("PERSON Vedligehold af").Controls("Sub Form BØRN til en forælder").Controls("Dato for forældreskabet")

06-02-1932



and that date IS IN FACT the birthdate of THE PERSON in THE FIRST ROW !

This works too, but still ONLY from the first ROW:

? FORMS![PERSON Vedligehold af]![Sub Form BØRN til en forælder].FORM.[FSDato]
But how do I reference the NEXT PERSONS birthdate - the person in the next rows 2, 3, ... ?

(I have tried to use the generator, but oh my ... it's so messy and it ends up with some code, that can't be executed without errors)

EDIT: Where is the screendump ??????

[June7]

That code should return value from whatever record has the focus.

What exactly are you trying to accomplish? Why do you need to pull birthdate?


Don't know why your image attachment failed.