hello, i have a database with Item Table with the following fields itemCode, Description, Utility
what i did was i implemented the following VB indicated below in a combo-box within a split-form where the source code is the item table
Code:
Private Sub CboFilter_Change()
If Nz(Me.CboFilter.Text) = "" Then
Me.Form.Filter = ""
Me.FilterOn = False
ElseIf Me.CboFilter.ListIndex <> -1 Then
Me.Form.Filter = "[Utility] = '" & _
Replace(Me.CboFilter.Text, "'", "'") & "'"
Me.FilterOn = True
Else
Me.Form.Filter = "[Utility] Like '*" & _
Replace(Me.CboFilter.Text, "'", "'") & "*'"
Me.FilterOn = True
End If
Me.CboFilter.SetFocus
Me.CboFilter.SelStart = Len(Me.CboFilter.Text)
End Sub
meaning whatever i type in the combo-box, will be filtered by the utility field, of the datasheet in the split form, this is ok an all
im looking for a way to add a second combo-box, and filter the description field, within the same datasheet, much like what im doing with the Utility Field but however without restarting the filter again
in other words, i don't want the 2 combo-box's Filters to cancel each other out, in the datasheet which they are filtering in the split form
in other words, i want to freeze the datasheet after filtering the Utility, so i may filter the description with in an already filtered by utility Datasheet,
thanks in advance