Selecting Multiple Records: Datasheet

[Guest]

Does anyone know a way to emulate the behavior of a multi-select list box in a continuous form (datasheet view)? E.g. I'd like to be able to hold the ctrl key while selecting non-contiguous records.

Thanks for any suggestions,

TomT

 

[Rick B]

Three posts are not needed.


Does anyone know a way to emulate the behavior of a multi-select list box in
a continuous form (datasheet view)? E.g. I'd like to be able to hold the
ctrl key while selecting non-contiguous records.

Thanks for any suggestions,

TomT

 

[John Vinson]

Does anyone know a way to emulate the behavior of a multi-select list box in a continuous form (datasheet view)? E.g. I'd like to be able to hold the ctrl key while selecting non-contiguous records.

I don't know of any way to do this, and (since a Form or subform can
only have one active record) I suspect it's not possible.

Instead, consider adding a yes/no field named SELECTED to your table
and put a checkbox on the form; select the records by checking it; and
then (after running your report or whatever) run an update query to
set the field back to False.

 

[Guest]

Thanks John, I was hoping to avoid that, but it appears it may be the only way. I was curious to see if there was something I had been missing all these years...

 

[Beth Melton]

Hi Tom,

They're working on the issue. This message you are encountering is for
your Notification. It means there was an error posting the
notification in your profile rather than your post in the newsgroup. I
know, the message doesn't sound like that - I've encountered it myself
and if wasn't already aware of the problem I would have created my
post again.

If you encounter the message again, log out and then log back in to
clear it up. Then click the "Notify me of replies" command after your
post shows up in the newsgroup.

The web interface is relatively new and they're still getting a few
bugs worked out.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

That was not particularly helpful.

Each time I posted, I got an error from the group saying the message

was not posted, so although I should not have, I trusted the message
and re-posted. If I could remove them, I would.

 

[Guest]

I'm trying to do something similar.....I have my form that lists policy
numbers. I have the yes/no check box. The user selects (clicks in the box)
on the ones they want to process.

Instead of the user having to click in each box, is there any way to maybe
create a button that will select all of the policies (change all the yes/no
boxes to yes)?? Like in a query or something? (I don't really know vba so
I'm kind of limited)

Any help would be greatly appreciated...... Thanks