can forms filter be set to eliminate records with null value?

[maxminh]

I am relative new to access, and was wondering if it is possible to filter a records by detecting if a certain field
is a null?

Here is my situation. I have a query that is a left outer join between table1 and table2, but some time I need to have an inner join between the two tables. I thought if I exclude records from the outer join where a field from table2 is null, I would get my inner join filter.

I have tried setting the "Filter" property of my form to:

[ID] is not null

"ID is not null"

ID is not null

where the ID field belongs to table2 only. Nothing seems to work. Please help. Thanks.

 

[dhookom]

Did you set FilterOn = True?
This code should work:

Private Sub cmdExcludeNulls_Click()
    Me.Filter = "ID is Not null"
    Me.FilterOn = True
End Sub

Duane
Hook'D on Access
MS Access MVP

 

[maxminh]

Ah that work! Thank you so much!