[AccessD] Setting form filter string

Charlotte Foust cfoust at infostatsystems.com
Thu Apr 9 15:45:15 CDT 2009


Well, I'm relieved to hear that not all my brain cells have died yet!
LOL

Charlotte 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Thursday, April 09, 2009 1:17 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Setting form filter string

After some experimentation, I discovered that my version of Access
2003/Win XP Pro is behaving as Charlotte said - I can't set Me.Filter to
the empty string without first setting Me.FilterOn to False.  However, I
can definitely change the filter string to a new, non-empty string
without setting FilterOn to False first.  Setting Me.FilterOn to True or
False does not change the filter string.

Doug Steele

On Wed, Apr 8, 2009 at 8:09 AM, Charlotte Foust
<cfoust at infostatsystems.com>wrote:

> It's necessary, weird or not.  You have to set the filteron property 
> to false before you can change the filter.
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list