Unbound Check Boxes on Datasheet View

[EddieN1]

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

[pbaldy]

As you've found, the check box would need to be bound to something. Is using a multi-select list box an option?

[EddieN1]

Not really. Although the user may select only a small number of rows, the available rows are in the range of 15,000. Also, there are a lot of fields on each row that the user maintains.

Do you know of a way to bind the control to a recordset that I maintain with VBA code to be in sync with the form's recordset?