I have an unbound form in an Access project (.adp) and I am having problems with refreshing a summary form from a detail form. I thought I had this issue fixed from an earlier post but there are new problems once I deploy to my users. I am using an adodb recordset to populate an unbound summay form and then allowing the user to select a record to edit. I take them to a detail form and allow them to update the record and then resync the summary form when they exit. It all works fine when I am designing but gives an "Insufficient key column information for updating" error when the users run it. I have given them the permissions on all the underlying stored procedures and the summary form opens for the user the first time. I'll post the releavant code. Any ideas?
Here is the recordset I use to populate the summary form with:
Dim oaNum As String
oaNum = Nz(Form_frmEngineeringHomePage.cboOaNumbers, "%")
Dim cmd As New ADODB.Command
Dim rst As New ADODB.Recordset
.ActiveConnection = CurrentProject.Connection
.CommandText = "spSelectENG_OverAndAboveDetails"
.CommandType = adCmdStoredProc
.CommandTimeout = 60000
.Parameters("@OA_Nr") = oaNum
rst.Open cmd, , , adLockOptimistic
Set Me.Recordset = rst
Here is the command I use from the detail table to resync the summary form:
If CurrentProject.AllForms("frmOaDetails").IsLoaded Then Form_frmOaDetails.Recordset.Resync