[AccessD] Setting form filter string

It's necessary, weird or not.  You have to set the filteron property to
false before you can change the filter.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Tuesday, April 07, 2009 7:31 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Setting form filter string

Hello All:

I discovered today that I couldn't assign the empty string to a form
filter in Access 2003:

Me.Filter = ""

left the filter string unchanged.  I couldn't assign a Null to it,
either.
Has anyone else run into this?  Help doesn't say anything.  The
workaround is to set Me.FilterOn to False instead, but it still seems
weird.

Doug Steele
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com