Jeremy Toves
itsame2000 at sbcglobal.net
Tue Aug 23 20:46:33 CDT 2005
John, This worked perfectly. There isn't much data. I'm just tracking work orders. There is no noticeable degradation in speed. Thanks, Jeremy "John W. Colby" <jwcolby at colbyconsulting.com> wrote: Open the form with the checkbox set to a default value, then in OnOpen requery the form - me.requery. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeremy Toves Sent: Tuesday, August 23, 2005 12:31 AM To: Access Developers Subject: [AccessD] Filter Problems I have a popup form that lists work orders as a continuous form. When it comes up, I want it only to list the active work orders. There is a check box on the popup that I can check to display all. This check box is meant to toggle back and forth between showing all and just the active work orders. The check box works, except when the form first comes up, it displays nothing. How can I have it display the actives without having to rewrite the SQL statement in VBA each time? I'm thinking there is a quick filter that can be used. Thanks, Jeremy -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com