All,
Thanks in advance for the help.
I have a form with 2 combo boxes, both able to filter a given field.
They both work fine in isolation, but I cannot make then filter together. When I run one filter the other turns off.
Here is the code for each Combo Box
Private Sub Combo317_AfterUpdate()
Select Case Me.Combo317
Case "Active"
Me.Filter = "Invbillrecon = -1" 'show only Active
'ReconInvBill
Me.FilterOn = True
Case "Inactive"
Me.Filter = "Invbillrecon = 0" 'show only inactive
Me.FilterOn = True
Case "all"
Me.FilterOn = False 'show everything
End Select
End Sub
Note: Default value is "Active"
Private Sub Combo319_AfterUpdate()
Select Case Me.Combo319
Case "Out Of Balance"
Me.Filter = "UnitsDiff <> 0" 'show only unreconciled
'ReconInvBill
Me.FilterOn = True
Case "In Balance"
Me.Filter = "UnitsDiff = 0" 'show only reconciled
Me.FilterOn = True
Case "all"
Me.FilterOn = False 'show everything
End Select
End Sub
Note: Default value is "<>0"
Really appreciate any help
For example, when the form opens it should filter to only the Invbillrecon field to Active records AND the UnitsDiff field to <> 0.
Thanks in advance for the help.
I have a form with 2 combo boxes, both able to filter a given field.
They both work fine in isolation, but I cannot make then filter together. When I run one filter the other turns off.
Here is the code for each Combo Box
Private Sub Combo317_AfterUpdate()
Select Case Me.Combo317
Case "Active"
Me.Filter = "Invbillrecon = -1" 'show only Active
'ReconInvBill
Me.FilterOn = True
Case "Inactive"
Me.Filter = "Invbillrecon = 0" 'show only inactive
Me.FilterOn = True
Case "all"
Me.FilterOn = False 'show everything
End Select
End Sub
Note: Default value is "Active"
Private Sub Combo319_AfterUpdate()
Select Case Me.Combo319
Case "Out Of Balance"
Me.Filter = "UnitsDiff <> 0" 'show only unreconciled
'ReconInvBill
Me.FilterOn = True
Case "In Balance"
Me.Filter = "UnitsDiff = 0" 'show only reconciled
Me.FilterOn = True
Case "all"
Me.FilterOn = False 'show everything
End Select
End Sub
Note: Default value is "<>0"
Really appreciate any help
For example, when the form opens it should filter to only the Invbillrecon field to Active records AND the UnitsDiff field to <> 0.