I'm trying to use code to filter a form field with the citeria being either one value or the other.
Me.frmSubmittalListSubForm.Form.Filter = "Status<>'Approved'" & "Or Status<>'Resubmitted'"
Me.frmSubmittalListSubForm.Form.FilterOn = True
The code runs, but doesn't filter.
What is my error?
Me.frmSubmittalListSubForm.Form.Filter = "Status<>'Approved'" & "Or Status<>'Resubmitted'"
Me.frmSubmittalListSubForm.Form.FilterOn = True
The code runs, but doesn't filter.
What is my error?