"Record set not updateable"

[jamaden]

I have created a form based off a query. I am also pulling in data from 2 different tables that have descriptions in them(ID for description is in my query that my form is based on). When trying to use the form I get the message "Resord set is not updateable."
In the properties box of the form and query it is set to allow edits, additions, etc. Can I eliminate this erorr when my form is based off of two tables and a query?? Any help is appreciated.

 

[Atomic Shrimp]

Whether you can or can't update the underlying tables from a query datasheet is dependent on a number of things, primarily the number of tables (two is OK) and the join/relationship type.

certainly if your query contains any group or aggregate functions, you're going to be stuck.

the online help is unusually lucid on this subject if you type in 'when can I update recordset'.

Mike

 

[Carol]

To get around this problem, set the Recordset for both the query and the form to Dynaset (Inconsistent Updates)

Good luck