Filter 2 fields with one Button

[JimO]

I have a form that I can filter with a button using the code,

Private Sub Idle_Click()
    Me.Filter = ""
    Me.FilterOn = False
    Me.Filter = "[StartTime] Is Null"
    Me.FilterOn = True
    Me.Caption = "Not Scheduled"
End Sub

This I would like add a filter for, to display data where both [StartTime] and [Progress] are Null. Each code works by themselves, I want to combine them.

Me.FilterOn ="[Progress] Is Null"

I have tried a few combinations with little to no success.

Jim O

[ranman256]

'one is a filter, one is the switch that turns the filter on/off

Me.Filter = "[StartTime] Is Null and [Progress] Is Null"
Me.FilterOn =true

[JimO]

Thank you for the response and explanation.

That works very well. Lots to learn and sites like this really help.

Jim O