filter

  • Thread starter Thread starter schmalen
  • Start date Start date
S

schmalen

How can you make a filter that filters a table on two
fields :i.e. you have a form with a research button. if
you click on the research button you can enter a criteria
(i.e. a name) and another form opens (filtered on this
criterea) where you can select the right record. Now how
can you do the same with two criterea (name and location
for example). I tried and I always had the form opened,
then it applied a filter on the first criteria, removed it
and applied a filter on the second criteria. The And
operator doesn't work for this to. How can you realize
that?
 
Concatenate the new expression onto the existing one, e.g.:
Me.Filter = Me.Filter & " AND Location = 9"
Me.FilterOn = True
 
Back
Top