If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007: bug? quick filter list is sometimes empty
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 |
#2
|
|||
|
|||
Access 2007: bug? quick filter list is sometimes empty
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 "Georg Scholz" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|