select multiple records

[attrib75]

I have a Macro that opens a form in datasheet view. The user wants to be
able to select multiple, individual records in that view, using the control
or shift button and clicking with the mouse. Right now you can select
multiple records using the shift button, but the records are selected
contiguously. You cant select a record by clicking, skip a few records, then
press the shift or control key to select an additional record further down
the list, without all the records in between being selected as well. The end
user claims they were able to do this at one point. Is this possible?
thanks!

 

[Tom van Stiphout]

On Tue, 6 Oct 2009 13:52:13 -0700, attrib75

Perhaps in a listbox with the MultiSelect property set to Extended.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

I have a Macro that opens a form in datasheet view. The user wants to be
able to select multiple, individual records in that view, using the control
or shift button and clicking with the mouse. Right now you can select
multiple records using the shift button, but the records are selected
contiguously. You cant select a record by clicking, skip a few records, then
press the shift or control key to select an additional record further down
the list, without all the records in between being selected as well. The end
user claims they were able to do this at one point. Is this possible?
thanks!

The only way I've ever known to do this on a Subform is to include a yes/no
field in the table (Selected, let's call it) and put it on the subform with a
checkbox. The user can then tick whichever records they wish. When you're done
with that set of records you can (if appropriate) run an Update query to set
them back to off.