Access 2007: bug? quick filter list is sometimes empty

[Georg Scholz]

Access 2007 has a great new feature which allows to easily filter by
selecting different values from a drop down box on top of each
column.

However, sometimes the list of values simply is EMPTY in some
columns.
It seems that this has to do with the complexity of the underlying
query.

Does anyone know how to circumvent this? Or is it simply a bug?

Kind regards
Georg

 

[Mark Andrews]

When the list of unique choices gets too big they don't show. You have some
control over this
office button/access options/current database/Filter lookup options (look at
bottom of screen).

It takes time to populate all these filter lists so you don't want 5000
items showing for example.

There are lots of other little quirks with this filtering, I'm sure I don't
know them all. I ended up always using
control names that are the same as the underlying field name (for example
don't use "ComboCompany" for a
dropdown control on "CompanyID", just use the "CompanyID" as the control
name). It helps with a few scenarios.

HTH,
Mark