Recordset is not Updateable

  • Thread starter Thread starter daniel
  • Start date Start date
D

daniel

I have a continuous form that finds the appointments that
meet a certain criteria. Then when I double-click on the
appointment on the continuous form to open the detailed
form I am not able to change the fields in the detailed
form. The message in the Tip Line at the bottom says
Recordset is not updateable. Why would that be? On
DoCmd.OpenForm I have the parameter set to acEdit. I have
other continuous forms that open detailed forms that allow
edits.

Thanks

Dan
 
Is the data that feeds the form driven by a query? if you
have a query with a 1-m relationship it will not allow you
to update the query. You will have to write some write
around to update the respective tables.

MW
 
What excactly do you mean by write around?

Dan


-----Original Message-----
Is the data that feeds the form driven by a query? if you
have a query with a 1-m relationship it will not allow you
to update the query. You will have to write some write
around to update the respective tables.

MW
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use of RecordSet 4
Recordset is not updateable 2
open form during recordset update 1
open record on one form from another form 1
Filter main form to records with no related records in subform,maintain updateable recordset 4
Run-Time Error 2501 The OpenForm action was cancelled 1
Filling continuous form with VBA recordset 4
Recordset in different colour 3

Back
Top