How to add a text field (seemingly) to a complex select query.
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Scott's UPDATE command was the ticket (plus an add record if one did not already exist) and was a huge help thanks to you both for your ideas!
ASKER