Filter form on load

[hithere]

I am trying to open a form where one of three dates cannot be null.



The form name is Review. I have the following code written in the button on another. Do.cmd.openform "Review",,, Date1 <> "" AND Date2 <> "" AND Date3 <> """ but this is not working. Is there any reason why? If this can be done if the filter properties of the Review form that would be great, I just can't seem to find an example anywhere.

[pbaldy]

If you always want it filtered, I'd base the form on a query with the appropriate criteria. In your case, there are a couple of problems If you really want to test for "", it would be:

Docmd.openform "Review",,, "Date1 <> '' AND Date2 <> '' AND Date3 <> ''"

If that's a date field, you probably want to test for Null:

Docmd.openform "Review",,, "Date1 Is Not Null AND Date2 Is Not Null AND Date3 Is Not Null"