Recordset is not updateable

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I am coming to an error when I open some forms. I have a
continuous form where the user can choose the desired
record to open a detailed form. The code on double-click
is as follows:

Private Sub fApptID_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmAppt", , , "[fApptID] = '" &
Me!fApptID & "'", acFormEdit
CurrentPtID = Me!fPtID
DoCmd.Close acForm, "frmApptList"
End Sub

When I try to update frmAppt with all the info it
says "Recordset is not updateable." I am unsure why this
happens in some cases and not in others. Does it matter on
what the first, continuous form is based on?

Thanks

Dan
 
Dan,

Question: Is your forms record source a query? If so, does
that query have multiple tables? If so, I would expect
that is your problem. If that is the case, setup your main
form on the main table and any other related tables on
subforms as necessary. If you need to filter the records
based on some criteria, open the form filtered. Your other
possibility is to leave the form unbound and use ADO or
DAO queries in VBA to append the record information to the
appropriate tables.

Hope that helps!

Kevin
 
Daniel said:
I am coming to an error when I open some forms. I have a
continuous form where the user can choose the desired
record to open a detailed form. The code on double-click
is as follows:

Private Sub fApptID_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmAppt", , , "[fApptID] = '" &
Me!fApptID & "'", acFormEdit
CurrentPtID = Me!fPtID
DoCmd.Close acForm, "frmApptList"
End Sub

When I try to update frmAppt with all the info it
says "Recordset is not updateable." I am unsure why this
happens in some cases and not in others. Does it matter on
what the first, continuous form is based on?
Click to expand...

It probably depends on the query the form is based on. See the help
topic "When can I update data from a query?"
 
Back
Top