根据查询过滤子表单。 [英] Filter subform based on a query .
问题描述
你好，
我正在使用MS Access 2007.现在如果我有一个基于表的子表单，过滤子表单非常容易。我只需单击子窗体上的相关列标题并选中/取消选中所需的记录（单击列标题会显示下拉列表）。
但是，由于我的子表单基于查询，我无法使用上述方法使用过滤器选项。我收到错误号码3075.
有人可以帮助我吗，
非常感谢。
问候，
Shreyans。
另外，作为替代方案我能做的就是有一个组合主窗体上的方框。组合框将具有例如采购订单号。所以我应该只看到那些承载采购订单的子表单中的记录，因为我从组合框中选择了该记录。
这可能吗？
提前致谢。
查看在表单上过滤示例。并查看是否有帮助。
否则你的解释并没有提供太多信息。
如果您需要更多帮助，请告诉我们。
查看在表单上过滤示例。并查看是否有帮助。
否则你的解释并没有提供太多信息。
如果您需要更多帮助，请告诉我们。
Well NeoPa感谢以上链接。我之前无法准确解释我的要求，因为我觉得它非常复杂。
无论如何，如果你能为我提供任何链接，我将会非常精彩，因为当我从主表单上的组合框中进行任何选择时，如何过滤子表单。
Hello ,
I am using MS Access 2007. Now if i ve a subform based on a table, filtering the subform is extremely easy . I only ve to click the relevant column head on the subform and check/uncheck the required records (clicking on the column head would yeild a drop down list).
However , since my subform is based on a query , i cannot avail the filter option using the above method. I get the error no 3075.
Can somebody please help me here,
Thanks a lot.
Regards,
Shreyans.
Also , as an alternate what i can do is have a combo box on the main form. The combo box will have for example purchase order no. So i should see only those records in subform which bears the purchase order no as i ve selected from the combo box.
Is this possible?
Thanks in advance.
Check out Example Filtering on a Form. and see if that helps.
Otherwise your explanation doesn''t really give much information.
Let us know if you need more help with this.
Check out Example Filtering on a Form. and see if that helps.
Otherwise your explanation doesn''t really give much information.
Let us know if you need more help with this.Well NeoPa thanks for the above link . I could nt explain my requirement precisely earlier because i think it is really very complicated.
Anyways i would be really greatful if u could provide me with any link as how do i filter a subform when i make any selection from a combo box which would be on the main form.
这篇关于根据查询过滤子表单。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
