How to get selected record value from a subform

[JackLeon]

I am trying to put in code in the Exit event of the subform to get the value of the selected row. I have been able to get the selected row using ".CurrentRecord" but am not able to get the row value using it. Say, the subform fields are Id, Name and Address and I want to show the value of Address for the selected row in a msgbox ... how could I accomplish that Thanks!!

[orange]

A sample would be helpful. Screen shot/capture.

[JackLeon]

I was trying something complex.. as soon as I tried it the simple way, it worked.. thanks anyway