Filtering Records in Form

[Rodney James]

Thanks for any help on this. here is what i am trying to do

In my form I want to be able to filter down what records users are working
with in the list.



I have a few drop down tables that the filter would be applied from: Project
Status, Project Type, Product Type



So for instance. I have 100 Records



I choose a field in Project status to a particular status "Project in
Progress" now I have 50 records in the form that match that criteria



I then choose a field in Project Type to a particular type "Lighting" now I
have 25 records in the form that match this and the preceding criteria.



I lastly choose a field Product Type and pear down the list to 5 records
based on the three fields



I want the filter to work based on any combination of the three fields

 

[Guest]

You can dynamically change the filtering (in VB event procedure) via the
DOCMD.APPLYFILTER command after each change. Look it up in Access Help.

Dorian

 

[Rodney James]

The only part i dont under stand in the coding is how to make it filter
based on what is in the box