I'm trying to update the value of a field in a table (the last record written to the table) based on the value of a field in a query. Here's my code which is not working: (It gets stuck on the RS.FindLast line of code)
Dim RS As DAO.Recordset
Set RS = CurrentDb.OpenRecordset("tblMemberRunningNotes")
RS.FindLast [MembRunNotesID] WHERE [MemberID] = DLast("updqryUpdateIHMGnotes", "MemberID")
RS!MemberID = DLast("[MemberID]", "tblIHMGNotes")
RS!RunningNote = DLast("[Running Note]", "tblIHMGNotes")
What is wrong with this?