Prev: Details of how Filter By Form works
Next: datasheet: ¿how to order by the 2nd column of a combobox?
From: golfinray on 4 May 2010 13:16
In one form I currently use:
Me.filter = "[district] = """ & Me.cbofilter & """"
Me.filteron = true

That gives me all my projects by school district. I can then look on the
filter property of the form and see the filter set for [district] = "district
name"
Now can I turn that filter off and change it to a different filter based on
the combo selection? And can I concatenate the filter when I do? For example,
when I pull up one district I want the projects of that district AND another
district also. So would I put
Me.filter = "[Little Rock] & [North Little Rock] = """ & Me.cbofilter & """"
If I want to see both districts projects when I come to that district name?
Thanks so much!!!!

--
Milton Purdy
ACCESS
State of Arkansas
From: Jeanette Cunningham on 4 May 2010 17:31
You can build up a string for a filter, very much the same as building a
string for a where clause.
Have a look at Allen Browne's sample search form which shows an easy way to
do this.

http://allenbrowne.com/ser-62.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"golfinray" <golfinray(a)discussions.microsoft.com> wrote in message
news:7BA31A5C-0122-4421-8A29-6213B15D76BD(a)microsoft.com...
> In one form I currently use:
> Me.filter = "[district] = """ & Me.cbofilter & """"
> Me.filteron = true
>
> That gives me all my projects by school district. I can then look on the
> filter property of the form and see the filter set for [district] =
> "district
> name"
> Now can I turn that filter off and change it to a different filter based
> on
> the combo selection? And can I concatenate the filter when I do? For
> example,
> when I pull up one district I want the projects of that district AND
> another
> district also. So would I put
> Me.filter = "[Little Rock] & [North Little Rock] = """ & Me.cbofilter &
> """"
> If I want to see both districts projects when I come to that district
> name?
> Thanks so much!!!!
>
> --
> Milton Purdy
> ACCESS
> State of Arkansas


 | 
Pages: 1
Prev: Details of how Filter By Form works
Next: datasheet: ¿how to order by the 2nd column of a combobox?