"Recordset is not updateable" error message

[kh59743]

I have a form (frmAssign) based on a query which when opened directly from the database window allows me to update any of the fields.

BUT when I open the same form from a coded button on a different form (frmLastAssignment), my efforts to update any of the fields are thwarted and "Recordset is not updateable" appears in the status bar.

Process That Will Let Me Update
Open frmAssign directly from database window.

Process That Won't Let Me Update
Open frmLastAssignment, click on "Continue" button to open frmAssign.

Any suggestions of what is happening and how to fix it would be greatly appreciated!

 

[llkhoutx]

Non-updatable recordsets are often the result of tables improperly linked it a query.

There have been numerous posts on the site regadring noupdatable recordsets. Have you searched this site?

 

[kh59743]

Thanks for getting back to me so quickly on this. However, the query only filters records from a single table, so there is no linking issues. Also, the query doesn't appear to be the problem since I can update in the query's datasheet and in the form based on that query when I open it directly form the database window.

The only time it becomes an issue is when I open the form from a button on another form.

Any other thoughts would be greatly appreciated. Thanks!

 

[llkhoutx]

Merely opening a form, in and of itself, will not lock a form.

I suggest you use the debugger to go through the code which opens the form. When the form is open, used the debugger immediate window the check the Enabled and Locked, Filter, FilterOn properties.

You might post the form's recordsource, as determined after the form is opened via the 2nd form. Maybe the 2nd form supplies an improper, but required, filter criteria.

Otherwise, I think that you are inadvertently locking the form.