I need to have a checkbox in a query, which will feed a datasheet form. however I have no idea how to achieve this.

The checkbox cannot exist in the underlying table as it is a lookup from an old mainframe system.

I need the checkbox so that users can select specific records returned from the query, in a datasheet view subform. in order for the selected records to be added to a different recordset.

Any help greatly appreciated