On the query results datasheet view, you can obviously filter values using the built-in dropdown on the column header. When just running a generic query, the dropdown contains value options that can be checked (similar to the way it is in Excel). However, I've noticed that once you add criteria to the query, these values go away. The dropdown is still there, and you can still use generic filtering (Equals, Contains, etc.), but the value list is gone.
Having these value options is a critical component of convincing our employees to embrace Access datasheets and work within our application as opposed to using older, less flexible Excel spreadsheets with data connections to the database. Therefore, I'm very motivated to figure out a way around this.
Has anyone else noticed this issue? If so, is there any workaround for this? I would prefer to avoid making special forms and solving this programmatically, as I have come to really like all of the features and flexibility of datasheets (one being this built-in filter value list).
Thank you.