View Full Version : selecting multiple records in a subform


Zigster
12-11-2001, 04:50 AM
Hello,

I have a form with a subform on it containing 5 text fields. I want to know if there is a way to select multiple records with the mouse - for copying, deleting, ect. I can highlight a single record and perform actions on it and it does as intended but if I highlight multiple records the actions are still only performed on the single record that was selected first in the set. Is there a way to have all the selected records acted upon? I know I can add another 'selected' field such as a checkbox and have it work that way, but I am looking to avoid that.

Any help is appreciated, thanks.

Zigster

David R
12-11-2001, 09:56 AM
Did you try click-dragging the record selectors of the records you want, then holding down Shift while right-clicking to get the action you want? That will keep Access from 'reselecting' just the record you're right-clicking on, which can get annoying in a hurry.

HTH,
David R

Zigster
12-11-2001, 11:25 AM
Thanks for the suggestion, I gave it another shot just in case but still no go. I have no problem highlighting more than one record, but when I select delete only the first record selected gets deleted, the others remain as they were.

When I hover over the scrollbar on the verticle, it tells me 'Record 2 of 15' and so on, is there a way to access this? Perhaps I can get something to work using this pice of info.

Zigster