ERROR RECORD SET NOT UPDATEABLE! 1

[ScottWood]

when i try to up date or add new data to a record in a form i get an error at the bottom of the screen telling me that the record set is not updateable.

 

[Guest_imported]

Be more specific; start by looking at the datasource of your form. Is it a query using outer joins, can you update it in your query-view, etc...

 

[dschomburg]

Is the Forms source a Table or Query?

 

[ScottWood]

The forms record source is a query using two tables.

thanks for the help.

 

[Dav43]

Do you have a calculation (ie SUM) in your query between the two tables?

 

[ScottWood]

no there are no sums in the query, its wierd because one of the check boxes seem to work but nothing else?

 

[ScottWood]

This may seem really strange but i have been adding all kinds off sums and things to my database and i am not geting the record set not updateable!?!?!

 

[ScottWood]

Hmmm k new update, i can edit and chage the records that i have added throught the tables but when i try and add a completely new record i cant edit at all!

Help please somebody!?

 

[gwinn7]

Check to see if you have 'AllowEdits' or 'AllowAdditions' in the form properties set to false. Also, check the 'Recordset Type' property and make sure it is set to 'Dynaset'.

Hope it helps.

Gary
gwinn7

 

[PaulF]

If you have set Unique Records to Yes, this could be the problem.

Also I have been able to update recordsets that were at one time "Not Updateable" by changing the Recordset Type from Dynaset to Dynaset (Inconsistent Updates)

PaulF

 

[ScottWood]

thanks a lot its now working i cahnged the recordset type from dynaset to dynaset(inconsistent updates) thanks a lot!