Recordset not updating ? (1 Viewer)


Registered User.
Local time
Today, 08:38
May 17, 2012
The following code is now not working ( whereas it was before ) It throws up no errors, and seems to run without a hitch.
If Not (rst1.BOF And rst1.EOF) Then
                With rst1
                    If .RecordCount = 1 Then
                        .Fields("Staff_ID") = staffid
                        .Fields("CalcStaff_Name") = Me.cboAssigned_To.Text
                    End If
                End With
            End If
        End If
    End If      '
    DoCmd.RunCommand acCmdSaveRecord
the values for the fields to update with, are as they should be ( checking with breakpoint ), and it selects the correct single record ( Dynaset so therefore should be updateable ). Thanks in advance if you can assist.:confused:


Registered User.
Local time
Today, 02:38
Jul 5, 2007
I assume there is some missing code, otherwise there are two too many End If lines but that should generate an error of its own.

Can you fire a msgbox to show your record count in rst1 right after .movefirst?

Is it possible the values to update are already the same as the values you are writing?

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom