I want to add a checkbox to a continuous form for temporarily marking selected records in a muti-user shared environment. I have been asked to do this without adding any new tables or fields to existing tables. I have reviewed as many of the previous ee Q&A as I can find on this topic and have only been able to find solutions that either suggest adding new database elements or writting rather complex VB code with subforms and dynamically created controls. I am not very experienced with SQL but have excellent VB coding skills. I would rather not go through the excesses of writting a lot of VB code when adding a simple table to the database would do the trick. But, because the owner of the database does not want to add new elements and some users will be accessing via a low bandwidth connection, I would like to do as much locally as possible.
Is there a way to build an SQL query that adds a temporary field to the resulting recordset that is not stored in the database but that can contain a changeable value?
Is there a way to add an unbound checkbox to the detail section of a continuous form that is instanced once per record, can contain it's own value, is accessable from VB, and provides to VB the record number to which it applies?