Opening a form with two filter criteria

  • Thread starter Thread starter John Constantine
  • Start date Start date
J

John Constantine

How do open a form that requires 2 filters


Say I have a form called “owners”
It has a field called “cars”
And a anoth field called “color”

I could go

Docmd.openform “owners”,,,”cars =’Honda’ “

To give me the all the Honda’s

But say I wanted all the “black” Hondas - how do I put the second
filter requirement in the above expression ?
 
Am 06.07.2011 16:30, schrieb John Constantine:
I could go

Docmd.openform “owners”,,,”cars =’Honda’ “

To give me the all the Honda’s

But say I wanted all the “black” Hondas - how do I put the second
filter requirement in the above expression ?
Click to expand...

very easy:
Docmd.openform “owners”,,,"cars = 'Honda' AND color = 'black'"

hth
 
How do open a form that requires 2 filters


Say I have a form called “owners”
It has a field called “cars”
And a anoth field called “color”

I could go

Docmd.openform “owners”,,,”cars =’Honda’ “

To give me the all the Honda’s

But say I wanted all the “black” Hondas - how do I put the second
filter requirement in the above expression ?
Click to expand...

The WhereCondition argument is simply the WHERE clause from a Query without
the keyword "WHERE". You can create a query in the query grid, and view it as
SQL - embedded in it will be a clause like

.... WHERE [Cars] = 'Honda' AND [Color] = 'Black'...

You can copy or transcribe this clause into your code as the WhereCondition.
It can include one or more AND and OR clauses, expressions, even subqueries;
it takes a bit of skull sweat to figure out how to construct the clause from
scratch, but it's very logical and can be useful.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Back
Top