Filter in VBA

[cbende2]

Hello all,

I have what should be a simple fix.

I have two fields [InReview] and [TestReviewed].

I'm trying to create a filter in the Onclick event of a button like so:

Me.Filter = "InReview Is Not Null" & "TestReviewed Is Not Null"
Me.FilterOn = true

This is not working for some reason. What is the correct way to concatenate a filter in VBA?

Thanks

[orange]

Try (untested)
Me.Filter = "InReview Is Not Null AND TestReviewed Is Not Null"
Me.FilterOn = true

[cbende2]

Yep, that worked, Thanks Orange.