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?
 
Top