Multi-select rows in form recordset

[tiger]

On a form several rows of data are displayed in the detail section.
The user can multi-select rows just like a list box by SHIFT/CTRL clicking the record selectors.
I want to scan the selected rows and extract data from them.

Using the Forms recordset or Recordsetclone (or any other) is the any way of identifying the selected rows please? eg Me.Recordset.Selected (this property does not appear to exist)
Getting the selected rows from a listbox is ok but is there a similar option for the form's recordset?
Thx

 

[John Big Booty]

I suspect that you are going to need someway to flag which of the records has been selected. A check box for example would do the trick.

 

[gemma-the-husky]

given the "delete" function recognizes the selected records, there must be some property you can use, you would think.

Having said that, I am struggling to find it!


Ok - try this link to a similar query. See if paul's idea helps

http://www.access-programmers.co.uk/forums/showthread.php?t=223666

 

[spikepl]

.SelHeight and selStart

But this stuff is tricky, because the moment you press a button the focus goes away to the button and selHeight is 0...so play with it. And btw: selHeight only applies to a contiguous list of records.