docmd.OpenReport [英] docmd.OpenReport

问题描述

我正在尝试打开报告以查看特定发票号的发票。我在网上看了，并且没能解决我的问题！请帮助，


我的代码是：

展开 | 选择 | Wrap < span class =codeDivider> | 行号

解决方案

< blockquote>报告的记录来源是什么？我相信WHERE claus（Forms！frmInvoiceQ.BuyersInvoiceNo = Me.Text296）必须与报告的记录源相关联。并且记录源不是表格....

更常见的方法是设计一个可以显示所有项目的报告。在这种情况下，不会过滤基础查询。


报表打开后会应用过滤器。 WhereCondition参数（DoCmd.OpenReport（））指定要应用的过滤。

什么是记录源报告？我相信WHERE claus（Forms！frmInvoiceQ.BuyersInvoiceNo = Me.Text296）必须与报告的记录源相关联。并且记录源不会是一个表单....

记录源是一个查询（qryCreateInvoiceBuy），它查找过滤器（发票号）的位置发票不是表格！frmInvoiceQ.BuyersInvoiceNo = Me.Text296。

I am trying to open a report to view an invoice for a specific invoice number. I have looked on the net and todate have not been able to resolve my problem! Help please,

My code is:

Expand|Select|Wrap|Line Numbers

解决方案

What''s the Record Source for the report? I believe the WHERE claus (Forms!frmInvoiceQ.BuyersInvoiceNo = Me.Text296) has to associate with the reports'' record source. And the record source would not be a form....

The more usual way of doing this is to design a report that CAN show ALL items. The underlying query would not be filtered in this case.

The report then has a filter applied when it is opened. The WhereCondition parameter (of DoCmd.OpenReport()) specifies the filtering to be applied.

What''s the Record Source for the report? I believe the WHERE claus (Forms!frmInvoiceQ.BuyersInvoiceNo = Me.Text296) has to associate with the reports'' record source. And the record source would not be a form....

The record source is a query(qryCreateInvoiceBuy) which looks for the filter (invoice no) the location of the invoice no being Forms!frmInvoiceQ.BuyersInvoiceNo = Me.Text296.

这篇关于docmd.OpenReport的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！