A reader’s trying to add info to a query but keeps getting a message “Recordset Not Updateable”.
Q: Roger Fisher writes: “I have an Access 2000 database that has a form that is based on a select query. When I try to type in a field on the form I get a message that “Recordset Not Updateable”. I get the same message if I try to add info in the query itself. I re-created the query to no avail.”
A: You may need to bind the form directly to a table, or to a non-updatable query. If you need to enter/edit data in multiple tables on a form, it is best to use a main form with a subform, so the main form can be bound to the main table, and one or more subforms each bound to the linked tables. That way you can avoid using a non-updatable query.
