Hi Guy's i am not sure where my issue is here, i am getting run time error 3020 Update Or CancelUpdate Without AddNew Or Edit
I have done this method several times but can't see the wood for the trees
rs5 is set as DAO.Recordset
stDN is set as string
stDN = "Send To Delivery Note"
i know there is 2 x records that = stDN
Code:
Set rs5 = CurrentDb.OpenRecordset("Select * From tblStock WHERE Status = '" & stDN & "'")
With rs5
Do Until rs5.EOF
.Edit
!Status = "Delivery"
rs5.MoveNext
.Update
Loop
End With
Set rs5 = Nothing