我的表单没有过滤 [英] My form isn't filtering

问题描述

我正在尝试根据用户ID过滤子表单，但没有进行过滤。我没有错误（运行时或编译器），但没有任何反应。我不会使用过滤器，所以我会认为我做错了，但我找不到它。


这是查询，子表单的记录源：

展开 | 选择 | Wrap | 行号

解决方案

这些字段是字符串值吗？因为如果它们需要用引号括起值。

该表将它们存储为数字。但是在表格中，我使用了来自不同表格的组合框查找，因此可见值是一个字符串。我正在尝试根据数值进行过滤，因为我认为这是正确的方法。


另外，如果我的过滤器出错了，就不会过滤输出所有记录而不是全部显示？

我不知道这是否是问题，但尝试翻转设置过滤器和打开过滤器的顺序。

I''m attempting to filter a subform based on a user ID, but no filter is taking place. I get no errors (run-time or compiler), but nothing happens. I don''t work with filters much so I would assume that I''m doing something wrong, but I can''t find it.

Here is the query that is the recordsource for the subform:

Expand|Select|Wrap|Line Numbers

解决方案

Are those fields string values? Because if they are you need to surround the values in quotes.

The table is storing them as numbers. However in the table I have them with a combo box lookup from a different table so the visible value is a string. I''m attempting to filter based in the numerical value as I believe that is the correct way to do it.

Also, if my filter was wrong, wouldn''t it filter out all of the records instead of showing them all?

I don''t know if this is the issue but try flipping the order of setting the filter and turning the filter on.

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