我有一个带有未绑定组合框的表单，用于根据用户选择的组合框值过滤子表单。子窗体基于从源表中提取数据的查询。可以在查询中的字段上过滤子窗体。当使用组合框时，子窗体过滤我想要的方式。问题是我想要一个命令按钮来打开一个报告，该报告显示过滤后的子窗体的当前显示结果。

我有一个使用单独查询作为记录源的报告。记录ID的查询条件设置为子表单中的记录ID字段。我遇到的问题是用作报表记录源的查询将仅从子窗体返回第一个值。

SQL语句如下。我尝试删除WHERE子句并使用其他联接类型。如果删除WHERE子句，则查询将返回源表中的所有记录，无论联接类型如何。如果我添加WHERE子句，则无论联接类型如何，它仅返回子表单中的第一条记录。

SELECT SubrecipientIDSheet.ID,SubrecipientIDSheet.AgencyID,AgencyIDSheet.SubgranteeLegalName,SubrecipientIDSheet.IsAmendment,SubrecipientIDSheet.RecordDate,SubrecipientIDSheet.HasSubrecipient,SubrecipientIDSheet.IsactiveSub,SubrecipientIDSheet.SubrecipientName,SubrecipientIDSheet.SubrepAddress,SubrecipientIDSheet.SubrepEHA,SubrecipientIDSheet.SubrepEHAVet,SubrecipientIDSheet.SubrepERA,SubrecipientIDSheet.SubrepESG,SubrecipientIDSheet.SubrepHSP,SubrecipientIDSheet.SubrepHTBA,SubrecipientIDSheet.SubrepLIHRF,SubrecipientIDSheet.SubrepSHAP,SubrecipientIDSheet.SubrepCounty1,SubrecipientIDSheet.SubrepCounty2,SubrecipientIDSheet.SubrepCounty3,SubrecipientIDSheet.SubrepAuthorizedRepresentative,SubrecipientIDSheet.SubrepRepTitle,SubrecipientIDSheet.SubrepEmail,SubrecipientIDSheet.SubrepPhone,SubrecipientIDSheet.SubrepTargetPop1,SubrecipientIDSheet.SubrepTargetPop2,SubrecipientIDSheet.SubrepTargetPop3,SubrecipientIDSheet.SubrepTargetPop4,SubrecipientIDSheet.SubrepOtherTargetPop,SubrecipientIDSheet.SubrepPrimaryService,SubrecipientIDSheet.SubrepCulturalSpecificPop,SubrecipientIDSheet.SubrepUseHMIS,SubrecipientIDSheet.SubrepHMISSupportPlan,SubrecipientIDSheet.SubrepDataReportMethod,SubrecipientIDSheet.DescripCurrentScope,SubrecipientIDSheet.DescripChangeScop,SubrecipientIDSheet.DescripWhyChange
FROM AgencyIDSheet INNER JOIN SubrecipientIDSheet ON AgencyIDSheet.ID = SubrecipientIDSheet.AgencyID
WHERE (SubrecipientIDSheet.ID) = [Forms]![Subrecipient Information].[Form]![SubrepSubform].[Form]![ID];