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

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
 
G

greg aka Bubba da Hut

Hey Tom,

believe you have to go:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Copy previous record into form field 0
Lookup current record with ComboBox, any changes create new record 3
subform selection to change detail record on mainform 2
Duplicate record in Form and Subform 0
Looping thru Subform Records 15
Subform Select record 1
Locate record in a subform 0

Top