Charlotte Foust
cfoust at infostatsystems.com
Mon Jul 28 18:53:31 CDT 2003
Me.RecordsetClone.RecordCount should give you the number of filtered records. You can update it in the Current event. Charlotte Foust -----Original Message----- From: Bruce Bruen [mailto:bbruen at bigpond.com] Sent: Monday, July 28, 2003 3:51 PM To: accessd at databaseadvisors.com Subject: [AccessD] OnFilter event (repeat) Hi List, Did not get an any interest in my previous post, so I'll give it another try under a new topic. The onFilter event fires before the filter is applied to a form. I need to get a record count after the filter is applied and display it. I cannot find any way of doing this. Has anyone got any ideas? Tia Bruce _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com