"recordset is not updateable"

[mercury]

Hi again

I have this form that is base on a query but unfortunately i cant change any of the information. Everytime i try to enter/change information it keeps saying "The Recordset is not updateable" but when i use the form as the control source it works but the Grand total i have isnt working. Do you have any solutions to this???I also attached the database.

The "List of All Suppliers1" has the control source of the Query and "List of All Suppliers2" has the control source of the form.

Mercury

 

[Len Boorman]

generally a recordset is not updateable if

There are any joins in the record source querie/s
There are any aggragation functions in the record source. That includes, Group By Min,Max etc

Len B

 

[aleb]

Try this one