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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WORD VBA Search and switch to advanced ... 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
filtering a form based on the values of a subform 0
Recordset.clone record count issue 3
Record Count Weirdness Access 2000 under XP 0
How do I set focus (and select text) on a text box on a modeless userform? 0
MS ACCESS: SEARCH in a split form 0
Append a wildcard to a text search string 3

Top