Listcount & ListIndex for datasheet rows?

  • Thread starter Thread starter Leif
  • Start date Start date
L

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
 
Leif said:
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.
Click to expand...

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?
Click to expand...

Nope.
 
Back
Top