多重过滤器...一种形式的组合框 [英] multi-filter ...combo box in one form

问题描述

嗨亲爱的

有8个组合框必须在RqryAnimalsRepoert上设置过滤器


如果我从一个组合框中选择一个项目，如 ; DamID" ...并留下其他" null"

报告必须将过滤器设为DamID。只留下另一个过滤器空白


...


请参阅附件

问候

Hi dears
there is 8 combo box must be make filter on "RqryAnimalsRepoert"

if i choose one items from one combo box like "DamID"...and leave other "null"
the report must be make filter as "DamID" only and leave the other filter blank

...

please, see the attached file
regards

附加文件

me.zip （74.1 KB，60 views）

Attached Files

me.zip (74.1 KB, 60 views)

推荐答案

你需要使用VBA测试组合框为null以构建过滤器字符串。抱歉，我无法打开工作中的附件。

You will need to use VBA to test for the combo boxes to be null to build your filter string. Sorry, I can''t open the attachment at work.

我做到了......通过此代码

i did it ...by this code

展开 | 选择 | Wrap | 行号

所以你使用这段代码让它工作，或者这是你尝试过的代码而且它不起作用？

So you got it to work using this code, or this is the code that you tried and it isn''t working?

这篇关于多重过滤器...一种形式的组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！