Help.
I am certain this is easy, and I just have a syntax error.
I have a subform that I'd like to filter with a command button.
The subform has a calculated field txtOpen with the value:
=IIf(IsNull([DateToContractor]),"Open","Closed")
I am trying the following code, with no luck.
Private Sub cmdOpenOnly_Click()
Me.frmRFIListSubForm.Form.Filter = "txtOpen='Open'"
Me.frmRFIListSubForm.Form.FilterOn = True
End Sub
I am certain this is easy, and I just have a syntax error.
I have a subform that I'd like to filter with a command button.
The subform has a calculated field txtOpen with the value:
=IIf(IsNull([DateToContractor]),"Open","Closed")
I am trying the following code, with no luck.
Private Sub cmdOpenOnly_Click()
Me.frmRFIListSubForm.Form.Filter = "txtOpen='Open'"
Me.frmRFIListSubForm.Form.FilterOn = True
End Sub