Form Filter question

G

golfinray

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!!!!
 
J

Jeanette Cunningham

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Isnull with a filter problem 4
Dirk Goldgar help please!!! 2
Percent Help 2
Help Please 6
Linked Fields not populating 2
Stuck on filter, help Please 3
VLOOKUP formula? 12
DLookUp 4

Top