Problem Updating Recordset

[JohnJ]

I have created a form based off a query which uses an SQL procedure to use input values from 2 combo boxes on a form. The resulting records are shown in a sub-form.

When trying to use the sub-form to amend record details I get the message "Record set is not updateable."
In the properties box of the form and query it is set to allow edits, additions, etc. I have set the Recordset Type to Dynaset with no luck.

As a novice with Access any help will be greatly appreciated as this is the last link in this application.

Many thanks.

 

[Pat Hartman]

Many things will make a recordset not updateable. Among them are:
1. aggregate functions - Sum(), Count(), Avg(), etc.
2. domain aggregate functions - DSum(), DCount(), etc.
3. not including all the key columns in the select clause.
4. not having update permission to all the tables.
5. one or more of the tables does not have a unique primary key.

You can find more information on the subject by finding harness.exe on the Microsoft Access download site. It goes over what makes a query not updateable in some detail.

 

[JohnJ]

Thanks Pat - indirectly you solved my problem. I downloaded the MS document as you suggested and, while it didn't directly answer my problem, when I looked at some of its examples I realised I was using an incorrect keyword in my SQL procedure.

It now works exactly as required.

Thank you.