Listcount & ListIndex for datasheet rows?

[Leif]

Does anyone know of a way, thru VBA, to determine what
rows (records) have been selected in the datasheet view of
a bound form?

For a listbox or combobox I would use listcount &
listindex. However, I can find no equivalent for rows
selected in datasheet. I've only found a property to
indicate the current record.

Also, it seems I cannot use Ctrl-Click to select certain
rows in a datasheet. Is there another way?

Thanks,
Leif

 

[Dirk Goldgar]

Does anyone know of a way, thru VBA, to determine what
rows (records) have been selected in the datasheet view of
a bound form?

For a listbox or combobox I would use listcount &
listindex. However, I can find no equivalent for rows
selected in datasheet. I've only found a property to
indicate the current record.

It's the SelTop and SelLength properties you want, I think.

Also, it seems I cannot use Ctrl-Click to select certain
rows in a datasheet. Is there another way?

Nope.

 

[Guest]

Me.CurrentRecord will give you the current record