使用查询条件查看两种不同的表单

本文介绍了使用查询条件查看两种不同的表单的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

您好， 我在收到报告时遇到问题。我有两种不同的形式，我希望能够运行相同的报告。 示例：表单（A）打开我在box1和box2中输入日期范围然后按运行报告按钮。当报告打开它寻找表格（B）上的box1和box2的日期范围 如果我只是按下确定并绕过问题框它仍将运行报告和工作正常，但我想这样做只会从目前使用的表单中查看标准。 在此先感谢

Hello, I am having a problem with a query attatched to a report. I have two different forms that I want to be able to run the same report with. Example: Form(A) is open I input a date range in box1 and box2 then press the Run Report Button. When the report goes to open its looking for the date range from box1 and box2 on Form(B) If i just press ok and bypass the question boxes it will still run the report and work fine, but I would like to make it so that it will only look at the Criteria from the Form that is currently being used. Thanks in advance

推荐答案

嗨Slenish 你在使用VBA吗？设置报告标准或者您是否在查询中放置了标准链接？ 我真的不明白你的意思 - 但我想这样做它只会查看当前使用的表单中的标准。 " - 你能进一步解释吗。 Mary Hi Slenish Are you using VBA to set the report criteria or have you put the criteria links in the query? I don''t really understand what you mean here - "but I would like to make it so that it will only look at the Criteria from the Form that is currently being used. " - can you explain further. Mary

Hello Mary， 感谢您的回复： D 我在查询中设置了条件链接。 示例：这是在查询中设置的 Hello Mary, Thanks for the reply :D I have the criteria links set in the Query. Example: this is set in the query 展开 | 选择 | Wrap | 行号

确定删除来自查询的条件并将运行报表的代码更改为以下内容... OK remove the criteria from the query and change the code that runs the report to something like the following... 展开 | 选择 | Wrap | 行号