Filter in subform

[Rolando]

Hello!

I need a help to crate a form with subform based on filter criteria.

I have tables:
Category
Post
Person
Order Detail
Order

In Category I have three fields yes/no (checkbox)
In Post I have ZIP and Post Name
In Person Name, Surname
….

Now I would like to create a form with subform where I can select person name
with dropdown menu. But records (names) in this Dropdown menu must be first
filtered by Category criteria with checkboxes and rest of records must be
filtered by Post criteria where I select Post Name from dropdown menu.

I don’t have any idea How to create this kind of form. I try everything but
no success. Did somebody have any idea how to do this or some kind of
solution withc will help me to solve this problem?

THX for any help

 

[Jeanette Cunningham]

Hi Rolando
have a look at the sample search form on this site

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


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia