Recordset not updateable?

[RahelWalther]

I want to enter info in a form and the following message gets displayed: recordset not updateable?

What do I have to change?

Rahel

 

[adevera]

Did you set or change the Alllow Edits, Allow Deletion on the form Properties ?

 

[RahelWalther]

Yes, set to YES.

Rahel

 

[adevera]

Are you using a query as a recordsource to the form or in your table structure most of your fields have default value...

If possible can you attached your database (erase all important data)

 

[RahelWalther]

e-mail

Hi Pat,

Can I have your e-mail to send you the database? That would be great. Thanks.

Also, I changed the underlying query of the form after the form has been created and added new fields. I thought that that is possible, but it might not be, because now I cannot enter any data anymore.
I also have aggregate data inn my query, fields that are calculated using other fields. Should I take them out and calculate the field in the form itself?


Rahel