I have a simple table that is shared by multiple users in datasheet view. I want to provide an unbound check box on the datasheet so that a user may select multiple rows by clicking on the check box. Then on some event, in VBA code, I want to do something with the rows that are checked. The reason that the check boxes need to be unbound and not contained in the table is that each user may select different rows at the same time.
I tried a small, local table that I linked to the main table by primary key, but when I tried to insert a new row, the system said the links didn't match and wouldn't do the insert.
The number of rows that would be checked at one time would be small, no more than 10 at a time, so if there were a way I could bind the control to a table in memory, that would work as well, however, I don't know how to do that.
Thanks, Eddie