G Guest Sep 13, 2007 #1 Can anyone give me code to create a message box when no records are found after the filter is applied. Regards
Can anyone give me code to create a message box when no records are found after the filter is applied. Regards
U UpRider Sep 13, 2007 #2 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
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
G Guest Sep 14, 2007 #3 Is there not a piece of code that can be entered into the 'On applyfilter' property of the form?
