Database or object is R/O...

[Steff_DK]

I have a form based on a calculated query.
To allow users to edit some of the non-calculated fields I change the form's recordsource to a non-calculated query, but I still get "Database or object is read only".

I tried putting "msgbox currentdb.udateable" just after where I change the recordsource and I get the message "True" so db should not be in read only state...

If I open the form with the non-calculated query as source to start with, I can update the fields just fine.

What do I need to add to my code after Form_frmMyform.RecordSource="qryWriteable" to allow writing to the recordset?

 

[john471]

Sounds risky ! How will you ensure the desired record is being updated, after you have changed the form's recordsource from one query to another ?

 

[Steff_DK]

I do either a save or undo before returning to the calculated form.