Reading field data in subform

[Max Moor]

Hi All,
I'm trying to get to a value in the currently selected record of a
subform. I was using the code below:


Me!MySubform.Form.Recordset.Fields(8)


Unfortunately, this returns the value of the first record in the
subform, not whichever one I select. Can someone help me with the correct
syntax?

Thanks, Max

 

[Max Moor]

Hi All,
I'm trying to get to a value in the currently selected record
of a
subform. I was using the code below:


Me!MySubform.Form.Recordset.Fields(8)

Sorry,
I gave up on bad data. It is doing as it should after all. My
problem is a different one. I'll post that separately.

- Max