Multiple rows' selection on datasheet

  • Thread starter Thread starter Vadim Rapp
  • Start date Start date
V

Vadim Rapp

On a form in datasheet or continuous forms view, the user selects several
rows using Shift-click; then he uses shortcut menu that calls VBA code, so
at the time of VBA execution, selection is still in place.

Is there a way to programmatically determine which rows are selected?

Related question: shift-click selects the range of adjucent rows; is there a
way to select multiple non-adjucent rows, normally done with ctrl-click in
windows applications ?


thanks,

Vadim
 
You can reference the selected rows with SelTop and SelHeight.

It is not possible to select non-contiguous rows in a datasheet. A
workaround might be a yes/no field in the underlying table, so the user can
click the checkbox on the desired rows and then perform some bulk operation
with them.
 
Check Access Help on SelTop and SelHeight Properties of the Form.

AFAIK, you cannot do non-contiguous selection in Form in Cts Form View.
 
Back
Top