My user wants to add a read-write row level field to a form backed by a complex select query where all existing tables are read-only. I can add a new table to the database with the necessary key fields to link it to the rows of select query, but I would like some guidance with the best approach including the methods to add the record and update fields. My VBA experience is mostly with Excel, but have written several simple Access applications.
I would like the field to appear in the form as if the field is always present even though it is not. I understand I will have to requery the form data and the user will experience some screen flashing.