2 Filters on 1 datasheet

[raffi]

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

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

[June7]

Apply both combobox inputs to the filter criteria. Review http://www.allenbrowne.com/ser-62.html

[raffi]

maybe we can hold down the filter toggle in the form, on the first combo-box after update event
maybe we can set to the other combo-box to not clear the filter on the datasheet by setting a before update event

or we can say, once the filter has been applied it will remain applied unless i click remove filter using RemoveFilter Button

[June7]

Filtering records with code doesn't work like that.

Must use both combobox inputs to construct filter criteria and apply to Filter property.