Find all selected rows in datasheet subform

[Sck]

I have a datasheet view subform that lists information about a set of transactions (couple hundred) . I need the user to be able to select multiple rows (not always continuous) and press a button to build an individual reports for each of the selected lines. I know this would be easy with a listbox but the user wants to be able to sort/filter the data in the subform (like working in Excel) then select the rows they want the report for. They also need to be able to copy the all the data (filtered or not) out of the subform. I have the report build code working with a single row selected but I cant figure out how to make it loop through the subform and find all the selected rows?



I considered having them filter the listing all the way to just the lines they want and build all the reports based on what is displayed but that is a lot more "user clicks" and I would prefer to keep it as simple as I can. (plus I am not sure I know how to make it print the full filtered list).

As a last resort, I can add a "Make Report For:" list box but it will clutter the form because I would have to add the ability to filter (multiple criteria) what displays in the listbox - basically duplicating what is in the subform.

Any guidance is appreciated.

sck

[June7]

How do you select non-continuous rows?

[Sck]

How do you select non-continuous rows?

Bummer, in my head i was thinking you could..... that is what i get for assuming.

either way i still need to figure out how to id the rows selected.

[CJ_London]

The usual way is for your recordsource to include a 'selected' field which would reside in your transactions table, or perhaps updates a variable in a form - see this link which may provide a solution

https://www.access-programmers.co.uk...t=multi+select

the problem with a 'selected' field in a table is if your app is multi user - you could have more than one user updating at a time

[Sck]

the problem with a 'selected' field in a table is if your app is multi user - you could have more than one user updating at a time

thanks, I will take a look at the link. it is multi user so the selected field may well be an issue.