Form filtering question

[jscriptor09]

Hi folks



I hava form with 20 or so items on it. It is fed from a table with several hundred records.

there are 5 records that the user would be most interested on using to filter down to specific set of records. Example, Date, Dept, ResposiblePerson ... and so on

When I open the form in view , I can select the Dept textbox, then click "Filter" from the Ribbon bar. This will present me with a list of Dept to choose from. Next I want to filter further by the ResposiblePerson. Again, I select the ResposiblePerson textbox, then click "Filter" from the Ribbon bar; but this time, I am not presented with a list of ResposiblePerson options. Now I am presented with "Sort A to Z", "Z to A", and "Text Filters". I am looking to same behavior as the first filter ... eg, a drop down with list of availble names (jim, mike, susan ...) to select from.

Is there a setting to make this happen? or I must creat a dropdown next to each text box to force multi filtering?

Thanks for you help.

Mike

[June7]

I observe the same issue and not sure why some of the controls will offer the list and some don't. Might have something to do with the value being a pk or fk in a join clause of form's RecordSource. I see that is the case on my form.

As an alternative review this http://datapigtechnologies.com/flash...tomfilter.html