Hi all,
I have a form that uses the code listed below on the after update of a combo box and list box to search for a selected Name.
(code for afterupdate for combo box)
- Private Sub Combo73_AfterUpdate()
-
' Find the record that matches the control.
-
Me.RecordsetClone.FindFirst "[Name] = '" & Me![Combo73] & "'"
-
Me.Bookmark = Me.RecordsetClone.Bookmark
-
End Sub
(code for afterupdate for list box)
- Private Sub List75_AfterUpdate()
-
' Find the record that matches the control.
-
Me.RecordsetClone.FindFirst "[Name] = '" & Me![List75] & "'"
-
Me.Bookmark = Me.RecordsetClone.Bookmark
-
End Sub
How would I add the ability to display an error message if the user tries to search for a Name that doesn't exist in the records?