Editing Error in Form 1

[leighchel]

I have a schedule form that all of a sudden will not let our data entry users (or admin) update and edit. I have checked all properties on the form and everything is set to allow editing. Permissions are correct and the form has worked before. The form, when closed, runs append queries, which in turn updates 4 master tables.

When you try and edit you receive the Error: "The Recordset is not updateable."

I am at a loss right now as to why this error now appears. Any ideas?

Thanks,

Michelle

 

[Geekmomz]

You need to check the JOINs on the query/ies underlying your form. Make sure that you have correctly related one-to-many, one-to-one, etc.

 

[leighchel]

That seemed to be one of the problems... thanks!

Michelle

 

[Geekmomz]

You're welcome. Glad to be of help.