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
.
 
Back
Top