通过Combobox过滤报告，包含3个子报告 [英] Filter Report with 3 subreports via Combobox

问题描述

Access 2007


我有一种感觉，可能有3-4种方法可以做到这一点（Macro，Me.Filter，Like" ，链接Child / Master字段，但我无法理解。


我有一个Combobox（ AstNameCbx ），我试图用于过滤报告和主报告中的3个子报告。此组合框的字段是 EmployeeID，AstFirstName，AstLastName 。以下是该组合框的记录源：

展开 | 选择 | Wrap | 行号

解决方案

在您的条件中第一个单引号后面有一个额外的空格，在结束单引号之前有一个额外的空格。

谢谢，兔子。我让Combobox过滤报告。现在对于日期，我试着把

展开 | 选择 | Wrap | 行号

每个帖子只回答一个问题是论坛政策。请查看此论坛的发布指南，并为新问题创建新主题。

Access 2007

I have a feeling there''s probably 3-4 ways to do this (Macro, Me.Filter, Like " " , Link Child/Master fields, but I can''t figure it out.

I have a Combobox (AstNameCbx) which I am trying to use to filter a report and the 3 subreports that lie within the main report. The fields for this combobox are EmployeeID, AstFirstName, AstLastName. Here is the Record Source for that Combobox:

Expand|Select|Wrap|Line Numbers

解决方案

You have an extra space after the first single quote in your criteria and an extra space before the closing single quote.

Thanks, Rabbit. I got the Combobox to filter the report. Now for the dates, I tried to put

Expand|Select|Wrap|Line Numbers

It is forum policy to answer only one question per thread. Please review this forum''s posting guidelines and create a new thread for the new question.

这篇关于通过Combobox过滤报告，包含3个子报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！