Filtering Records in Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rodney James - 31 Jul 2006 20:21 GMT

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

Reply to this Message

mscertified - 31 Jul 2006 20:44 GMT

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

> Thanks for any help on this. here is what i am trying to do
>
[quoted text clipped - 16 lines]
>
> I want the filter to work based on any combination of the three fields

Reply to this Message

Rodney James - 04 Aug 2006 15:04 GMT

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

> You can dynamically change the filtering (in VB event procedure) via the
> DOCMD.APPLYFILTER command after each change. Look it up in Access Help.
[quoted text clipped - 24 lines]
>>
>> I want the filter to work based on any combination of the three fields

Reply to this Message