How to find out what row(s) is/are selected?

[Chatbox]

I have a subform (datasheet view) inside a form.
The subform is filled by a query based on data input by the user.
From within the subform, the user will then select a particular row. How do I know what row the user had selected?

Please help, I'm soooo new to Access.

 

[WayneRyan]

Chat,

You really don't select rows/columns like in a spreadsheet. On your subform,
if the user highlights a record, it is the Current Record. You can only have
one Current Record at a time.

If you reference one of your fields (e.g. [LastName]), it will have a value
like 'Smith'. The other fields will take on the values in that row.

Not a real good explanation, but I really don't understand your question.

Wayne

 

[Chatbox]

Ah....I see what you mean...thanks.

(So it's quite different from PowerBuilder...)

 

[m_ologin]

I see how CurrentRecord returns the selected record... But how about if there were multiple rows selected? (using Shift for ex.) Is there a way to find out which rows are currently selected?