I have the following coding in a Access 2007 form with Sub Forms. I have a find button that on click the
coding finds the record in the database. However, I need a messag box to appear when find is selected and no records are found. Where do I put this and what coding do I use?
Private Sub Command9_Click()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[PK_DriverLicenseID] = '" & Me.Text10 & "'"
If Not rs.EOF Then
Me.Bookmark = rs.Bookmark