数据表过滤问题 [英] Datasheet filter problem

问题描述

我有一个在数据表视图中有子表单的表单。在Access 2007中，每列都有一个箭头，允许我设置过滤器。当我点击箭头时，我会选择要过滤的记录，如下所示：

Hi,
I have a form which has a subform in datasheet view. In access 2007, there is an arrow by each column which allows me to set a filter. Ussually when i click the arrow, i get a choice of records to filter by as shown below:

推荐答案

我可以在数据表视图中使用子表单复制它。您可以将文本或数字过滤器添加到另一列，但它不会为您提供已过滤选项的列表。它看起来像是对程序的限制。

I can duplicate this with a subform in data sheet view. You can add a text or number filter to another column, but it will not give you a list of filtered choices. It looks to me like a limitation of the program.

谢谢快速回复。奇怪的是它可以在一个子表格数据表中工作，但不能在另一个子表格数据表中工作。让我觉得这是一个设置，只是不确定是哪一个。任何想法？


Leon

Hi, thanks for the quick reply. The wierd thing is that it works in one subform datasheet but not another. Makes me think that it is a setting, just not sure which one. Any ideas?

Leon

那么，它是第二列还是它是特定列的事实停止它给出过滤器选项？

So, is it the fact that it''s the second column or that it''s a particular column that stops it giving the filter options?

这篇关于数据表过滤问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！