应用按表单筛选报告 [英] Apply Filter By Form to Report

问题描述

我的用户正在使用from上的Sort& Filter选项。具体来说，他们使用高级>>按窗体过滤选项，然后选择供应商并将该过滤器应用于表单。


在应用此表单过滤后，他们希望能够打开一个报告并让它只显示他们刚刚过滤的记录。


我们正在使用Access 2013，有没有人有关于我们如何实现这一目标的建议？

I have users who are using the Sort&Filter options on a from. Specifically they are using the Advanced>>Filter By Form option and then selecting a Vendor and applying that filter to the form.

After this Filter by form is applied they would like to be able to open the a report and have it only show the records they just filtered on.

We are using Access 2013, does anyone have suggestions on how we can accomplish this?

推荐答案

使用 .Filter 打开报表的调用中表单的属性。

Use the .Filter property of the form in the call to open the report.

所以我可以在报表的OnLoad事件中做一些事情来引用表单过滤器？


或者我可以在报表上使用Filter On Load属性并将其设置为yes ..但是这样就留下了我在Filter属性中引用的问题报告？

So i could do something in the OnLoad Event of the report to reference the form filter?

or can i use the Filter On Load property on the report and set it to yes..but that leaves the question what do i reference in the Filter property on the report?

其实我弄清楚了。


我接受了基础查询并将其更改为在查看表单的供应商字段上有标准。因此，如果他们对表单进行排序并转到报告，它将基于报告中当前的内容。

Actually i figure it out.

I took the underlying query and changed it to have criteria on the vendor field that was looking at the form. So if they sort on the form and go to the report it will be based on what is currently on the report.

这篇关于应用按表单筛选报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！