I'm wondering if there is anyway I can use 2 filters on my form, so that when I use the first filter the 2nd filter only filters the information from the first filter (not the full query.)

Each filter works separately at the moment.

Private Sub cboFilterYear_AfterUpdate()

Me.Filter = "FieldYear = " & Me.cboFilterYear
Me.FilterOn = True
End Sub

Private Sub cboFilterField_AfterUpdate()
Me.Filter = "FieldNumber = " & Me.cboFilterField
Me.FilterOn = True
End Sub

Any help is much appreciated. I don't have much experience with Access development.

Thanks