[AccessD] OpenForm WHERE clause

Susan,

I may be wrong, but I believe the values for controls are not set until the
form's load event.  Does your code work in the form's load event?

John V. Ruff - The Eternal Optimist :-)

"Commit to the Lord whatever you do,
	and your plans will succeed." Proverbs 16:3



-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, January 31, 2003 6:46 PM
To: AccessD at databaseadvisors.com
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