Datasheet form filter combo box with specific value and blanks (1 Viewer)

[Hedge01]

Hi i have a subform that is a datasheet view and i want to filter the records that have "Adam" as the value plus the records that are blank in the same field.

Private Sub Check45_Click()
If Me.Check45.Value = True Then
Me.NotEmptySubform.Form.Filter = "CTGOPP = 'Adam'" Or CTGOPP IsNull
Me.NotEmptySubform.Form.FilterOn = True
Me.NotEmptySubform.Form.Requery

Else
Me.NotEmptySubform.Form.FilterOn = False

 

[arnelgp]

Me.NotEmptySubform.Form.Filter = "(CTGOPP = 'Adam') Or (CTGOPP IsNull)"

or

Me.NotEmptySubform.Form.Filter = "(CTGOPP = 'Adam') Or IsNull(CTGOPP)"

 

[Hedge01]

Thanks for you input I really appreciate it.

The first option returns a syntax error (missing operator) in query expression . Am i missing brackets somewhere?

The second option filters "Adam," but does not return the null values.

 

[arnelgp]

i tested the 2nd and it does return the CTGOPP with Null values.

the first has error, should be:

.... Or (CTGOPP Is Null)"

 

[Hedge01]

It works on the second line I had a naming issue that I fixed thanks so much for you help!