in access 2010 open a form with vba and filter by a null value


i want to write this code in vba in some vba action that will open the form "FileManagerF" Where the startDate Field Is Null but for some reason vba don't accept my formula
DoCmd.OpenForm "FileManagerF", , , StartDate <> ""

thanks a lot
Who is Participating?
mbizupConnect With a Mentor Commented:
It should be

"StartDate IS Null"

(Including the quotes )
Tony HungateDirector of TrainingCommented:
Are you attempting to populate the form with any data?  If not sounds like you just need to open to a new record and go form there.

Docmd.OpenForm "FileManagerF"
DoCmd.GoToRecord , , acNewRec

Open in new window

bill201Author Commented:
i don't want to go to a new record. i want to go  to a record that missing data in the  field "Startdate"
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.