Multiple filter problem.

[ducecoop]

I have a form that on the “OPEN” event does this:
Private Sub Form_Open(Cancel As Integer)
Me.Filter = "Inactive = 0"
Me.FilterOn = True
End Sub

To only show records that are active.

However the form has a few filters on it and when they are used the inactive records show
Example:
Private Sub cboCampus_AfterUpdate()
DoCmd.ShowAllRecords


Me.Filter = "Campus = '" & cboCampus & "'"
Me.FilterOn = True
End Sub

When I add:
Me.Filter = "Inactive = 0"
To the code above it does not work
What am I missing here

Tia

Dave

[pbaldy]

You need to put them together:

Me.Filter = "Campus = '" & cboCampus & "' AND Inactive = 0"

[ducecoop]

I actually had tried that but had my Quoits wrong.

Thanks much sir

dave