Unanswered: Run-time error '-2147352567 (80020009)': This Recordset is not updateable.
I am currently getting this error message when opening a form from a DblClick function on another form.
This is the code that I am using:
Private Sub Completed_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmSurveyResponses"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Me.SrvID = Forms!frmSurveyResponses!SrvID
frmSurveyResponses has set as it's RecordSource a SELECT DISTINCTROW query with data from 2 tables. These 2 tables are linked by a One-to-Many join on the SrvID field.
The field which I want the SrvID data included in has SrvID as its control source and it's name is cboSrvID. Hence, I have also tried this in my code:
Does anyone know what could be the cause of this? Is it because of the relationship at the heart of the form that the recordset is not updateable? Are there any variables I can change which might make it updateable?
Yep, there's no problems whatsoever typing the ID straight into the field. And by doing it manually there is no problem whatsoever. It's just when I'm opening the form from another that I get this error message, but I really need for this to work as part of the database.
Can you change the code to Me.SrvID = 7 or some other hard coded value? I don't think it's the code that's the problem tbh, the code looks fine. I have a suspicion it's the SQL of the form or a data type problem, but yeah, I don't think the code you have posted is the culprit.