Record do not exist

H

HOW1

Can anyone give me code to create a message box when no records are found
after the filter is applied.

Regards
 
U

UpRider

From within the form's code module:
me.recordsetclone.movelast
debug.print me.recordsetclone.recordcount & " record/s"

from another module (the form must be open for this to work)
debug.print forms!yourFormName.recordsetclone.recordcount & " record/s"

UpRider
 
H

HOW1

Is there not a piece of code that can be entered into the 'On applyfilter'
property of the form?
 

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

My Visio2019 Keep Crashed when open the program 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Adding data to MS Access from csv file 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Improving Macro That Keeps First Letter 0
2 Level Record Protection 0
Mail Merge skipping records/sending one at a time 0
Copy previous record into form field 0

Top