I have a Suppliers table with 3 fields (code,name,addr).
I have a Form where I need to list all records in this table + a checkbox against each record on which the user will tick for only some suppliers he wishes to select.
How can I do this without this??
I dont want to create a table just for this. Is there a way I can populate these records into a temporary Recordset & Add a field to it, and then assign this recordset to the Form???

I have a Form where I need to list all records in this table + a checkbox against each record on which the user will tick for only some suppliers he wishes to select.
How can I do this without this??
I dont want to create a table just for this. Is there a way I can populate these records into a temporary Recordset & Add a field to it, and then assign this recordset to the Form???