if search comes back with no results

  • Thread starter Thread starter Glenn
  • Start date Start date
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.
 
thanks for the answer but it doesnt seem to be working.
says something about recordset not being right or
something like that.
 
Back
Top