Filter OnOpen

[John]

I am trying filter records when the form is open. When I
read the heip files I am still confused. I have tried the
following:

Private Sub Form_Open(Cancel As Integer)

DoCmd.SelectObject acTable, "tblSalesOrders", True
DoCmd.ApplyFilter , "COM004StopDate = 'Null'"
(Runtime error 2488)

And

Me.Filter = "COM004StopDate = Null"
Me.Form.FilterOn = True

(Always filters all and goes to new record)

Thanks
John

 

[Allen Browne]

Nothing ever equals null.

Try:
Me.Filter = "COM004StopDate Is Null"
Me.FilterOn = True

For an explanation of why two Nulls are not considered equal, see Error #3
in:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html