How to get a current record on the subform with multiple records displaied?

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hello,

I run Access 97 on Win XP.
I want to refer to a current record on the subform that displays multiple
records on a datasheet. When I refer to ME("field_name").value I get the
value of a field from the first record of a datasheet.
How to get a value of the current record that the cursor is on.

Any help is greatly appreciated,
Tom
 
Hey Tom,

believe you have to go:

Forms![MyMainForm]![MySubForm].Form![FieldName]
 
Back
Top