access currentRecord

[fdelval]

Hello all!



I want to retrieve the fields of the selected value in a subform

I have a form with a subform inside in access 2003.

If i select a row in that subform, with this code:
[mySubform].Form.CurrentRecord i can get the number of the row, ie: 1 if is the first row.


Now, how can i retrieve a value of a field of that record??

[fdelval]

i mean:

id - address - name
1 street paul
2 street betty
3 road idontknow

if i am currently selecting the second row, how can i get the name, which is betty?

[RuralGuy]

Reference the control in the SubForm as this link describes:
http://www.mvps.org/access/forms/frm0031.htm