[AccessD] OpenForm WHERE clause

Susan,

It's not clear what you are trying to do but
you may be thinking of NZ(Field, SomethingElse)

Mike Mattys

----- Original Message -----
From: "Susan Harkins" <harkins at iglou.com>
To: <AccessD at databaseadvisors.com>
Sent: Friday, January 31, 2003 9:45 PM
Subject: [AccessD] OpenForm WHERE clause


> I think this got lost in the shuffle the other day.
>
> I'm setting a number of filters for a form using OpenForm. All of the
> filters will use Is Null or Not Is Null for different fields, sometimes
two
> fields -- but always Is Null or Not Is Null. I've tried a number of
> different syntax without success.
>
> DoCmd.Openform formname, , WHERE clause
>
> I've tried Is Null as a string, not as a string, I've used the IsNull
> function in the form
>
> "field = " & IsNull(field)
>
> and even tried it all as a string... never could get it to work. I feel
> really stupid -- this should be easy.
>
> Susan H.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com