When I put the cursor into the Combo Box then start typing a name, it sometimes says,
Run time error '2001':
You canceled the previous operation.
The debugger then comes up highlighting the Me.Bookmark = rs.Bookmark line:
The Combo Box's AfterUpdate()
Run time error '2001':
You canceled the previous operation.
The debugger then comes up highlighting the Me.Bookmark = rs.Bookmark line:
The Combo Box's AfterUpdate()
Code:
Dim rs As Object
Set rs = Me.RecordsetClone
rs.FindFirst "[Soc Sec #] = '" & Me![Names Combo Box] & "'"
Me.Bookmark = rs.Bookmark