I have a button that searches for the first occurrence of a record. If no records match the criteria input by the user, I know how to display a message saying that no records were found. But if a record is found, the user can then click a find next button. How do I display a message saying that no FURTHER records were found? I am using the FindNext method in my find next button as follows:
Me.Recordset.FindNext "[FIELD] LIKE '" & "*" & strCriteria & "*" & "'"
Any help here would be greatly appreciated!
Me.Recordset.FindNext "[FIELD] LIKE '" & "*" & strCriteria & "*" & "'"
Any help here would be greatly appreciated!