[AccessD] Setting form filter string

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

Uhhh... we haven't yet determined that!

John W. Colby
www.ColbyConsulting.com


Charlotte Foust wrote:
> 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
>