Multiple rows' selection on datasheet

[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

 

[Allen Browne]

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.

 

[Van T. Dinh]

Check Access Help on SelTop and SelHeight Properties of the Form.

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