Filtering query results by column in datasheet view

[rmunteanu]

Hi, I have a problem with manually filtering data in results of a query (Datasheet view).I am using access 2007. In some fields I can filter the data by selecting the column header and clicking toggle buttons on each data value in the filter list (Like in excel 2007). But in some columns (fields) that in not possible, I can only filter by using text filter options ("equal to" or "contains" etc.).
Does anyone know how to make this available for all fields (columns).
Thanks.

 

[Galaxiom]

In Access Options - Current Database there are settings for Filter Lookup options.
Perhaps you only have the option for Indexed fields turned on?

Non-indexed local fields and ODBC fields in particular would be much slower which is why there is an option to turn off the listing.

 

[rmunteanu]

Hi,
This kinda solved the problem but there is only one aspect. In a query this works fine now, but I have a form that uses a query as data source. The form is used in datasheet view and filtering does not work there. what could be the problem? I think these are ODBC fields that I want to filter.
Thanks.

 

[Galaxiom]

The form is a different kind of object. It gets its data from the query but, despite appearances, the datasheet view of a form is not the same as the query itself. So you don't necessarily get the same features.

The subdatasheet expander (+) seen next to records in queries and tables are also not available in a form built on those queries or tables.

Filtering similar to the right click menu of the indexed table fields can be done on a form using other techniques such as selecting the desired values to be used in the filter as checkboxes or listboxes etc placed on the form.

A popup form could even be designed to look and function exactly as the right click does in the table.