I have a listbox that lists the records entered above in several textboxes on the form. If I double click on a particular record in the listbox, it sends the fields to my text boxes, but I really am just getting the row info and and NOT the record I want, because after updating I now get TWO records with original and edited text.
Has anyone had to do this before? I have been experimenting with Listcount and looping through the recordset, but I can't seem to find a way.
Here's my code:
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("tblCaseNotes", dbOpenDynaset)
.FindFirst ("[CaseNotesID] = " & "'" & Me.CaseNotesID.Value & "'")
If Not .NoMatch Then
!CaseNoteDate = Me.CaseNoteDate.Value
!CaseNoteSubject = Me.CaseNoteSubject
!CaseNoteText = Me.CaseNoteText
MsgBox "Record not found"