Datasheet Form Filter By Multiple Fields

[snoopy2003]

Hello,

I have a datasheet form and I wish to filter by multiple fields.
If I click on one field arrow I can choose field values for filter.
If I click on second filed I do not see field values and can define Text Filter (write a value for filtering).

How can I define my form to allow multiple field filtering with ability to select values in each filed by clicking on the field name ?

Thank you for your help

[June7]

Do NOT use bound data controls to input filter criteria. This will change the value in the table.

Refer to tutorials at http://www.datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in Access Forms: Control Basics section.

[snoopy2003]

Hello,

Thank you for your answer.
I do not use controls to filter.
I wish to do it like in Excel - when the form displayed in datasheet view, I right click on the arrow near the field name
and filter by values. How can select values in multiple fields ?

Thank you for your help

[June7]

Access does not have that functionality with the shortcuts.

Sorting is on only one field at a time.

Filtering can be done in stages. Filter then filter again then filter again, etc.

This is what queries are for.

[snoopy2003]

Thank you for your answer.