if search comes back with no results

G

Glenn

In the event procedure of the search button add the
following code at the end:

if Me.RecordsetClone.RecordCount = 0 then
MsgBox "There are no records matching criteria."
End If

Glenn.
 
J

jason

thanks for the answer but it doesnt seem to be working.
says something about recordset not being right or
something like that.
 
Top