Retrieving data from currently selected row in a results subform

[memberFDIC]

I am using a Filter on a results subform and would like to know how to retrieve data from the currently selected row.

1) How do I know what row the user has placed their mouse cursor onto?

2) How do I retrieve data from a particular cell/field in that currently selected row?


E.g.,

Me.Results.Form.Filter = "(ZIPCODE > 22401) and (ZIPCODE < 23000)"

This generates 24 results. The user clicks on the 3rd row. How do I retrieve the data in the CITY field for row #3 in the results subform?

Thanks.

 

[MajP]

The value of that form field is the value of the selected row.

if calling from the parent form

= me.subformControlName.Form.fieldName.value

If the code is in the subform
= me.fieldName.value