[AccessD] OpenForm WHERE clause

Susan Harkins harkins at iglou.com
Fri Jan 31 23:31:31 CST 2003


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.




More information about the AccessD mailing list