Datasheet - Custom fields to behave independently for each row

[Pimped]

Hi Guys

Got datasheet on forms. Want to add a "Pay" check box to each row and want to have a "pay selected" button to look at rows where the "pay" check is selected.

How do i get the check boxes to act independently on each row and how do I refer to each individual check box programatically in VBA?

Thanks

[Pimped]

I solved this by putting a yes/no field in the table that the rows wre listed from.

Upon select of the checkbox, the value would be set to -1, i would just traverse through the recordset, find the -1's and act on them.

Once I had done all the -1's I would simply update the table to set all the checkboxes back to 0.