更新时间:2022-10-17 20:56:38
这些字段是字符串值吗?因为如果它们需要用引号括起值。
该表将它们存储为数字。但是在表格中,我使用了来自不同表格的组合框查找,因此可见值是一个字符串。我正在尝试根据数值进行过滤,因为我认为这是正确的方法。
另外,如果我的过滤器出错了,就不会过滤输出所有记录而不是全部显示?
我不知道这是否是问题,但尝试翻转设置过滤器和打开过滤器的顺序。
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:
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.