Filter on existing filter

[jnkt29]

Hello. I am new posting questions and would consider myself an intermediate
user in Access. I have created a form based off of a table. I have a primary
filter that allows me to select by "Brand" (ie. Brand A, Brand B, Brand C,
etc). I have basically copied that filter in design mode and pasted it to the
same form. I would like to have it now filter by "Job Function" (ie. Job A,
Job B, Job C, etc). After adding the second filter...instead of being a
"subset" to the "Brand" filter, it unfilters the "Brand" and refilters by
"Job Function". Might you have any suggestions how I can have my "Job
Function" filter be a subset of my "Brand" filter? Thank you for any help you
may provide.

 

[John W. Vinson]

Hello. I am new posting questions and would consider myself an intermediate
user in Access. I have created a form based off of a table. I have a primary
filter that allows me to select by "Brand" (ie. Brand A, Brand B, Brand C,
etc). I have basically copied that filter in design mode and pasted it to the
same form. I would like to have it now filter by "Job Function" (ie. Job A,
Job B, Job C, etc). After adding the second filter...instead of being a
"subset" to the "Brand" filter, it unfilters the "Brand" and refilters by
"Job Function". Might you have any suggestions how I can have my "Job
Function" filter be a subset of my "Brand" filter? Thank you for any help you
may provide.

A Form can have only one Filter, but a) it can be a composite filter filtering
on two, or three, or ten fields; and b) it can be changed.

The Filter property of a form is a text string containing a valid SQL WHERE
clause without the WHERE keyword, e.g.

[Brand] = "BRAND A"

or

[Job Function] = "Job A"

It sounds from your description that you want a multifield filter:

[Brand] = "BRAND A" AND [Job Function] = "JOB B"

Try creating a Query which returns the records that you want to see, and look
at the sql WHERE clause to get the syntax.