dLookup in Subreport UNSUCCESSFUL compared to use in Report

[sanders720]

=DLookUp("[Customer]","[Customer]","[Customer ID] = '" & [Reports]![rptInquiryInfo]![CustomerID] & "' &quot

This recordsource command works great in my report, but produces errors in the sub report.

Any thoughts?

Thankyou in advance for the help...

 

[WildHare]

You may need to specifically reference the subreport control name. Is "rptInquiryInfo" the name of your report or your subreport? Is this expression on the report or the subreport?

You tend to need to be very specific so Access knows where that "CustomerID" guy is...

78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[sanders720]

The control name is the same, for it is the same report! There is a source object property called Report.rptInquiryInfo.

The report that the sub report exists in is called rptQuotesInfo. Do I need to do something differently in my dlookup statement below? Remember, it works great in the report by itself.


=DLookUp("[Customer]","[Customer]","[Customer ID] = '" & [Reports]![rptInquiryInfo]![CustomerID] & "' &quot

Thanks again...

 

[WildHare]

If the syntax is anything like what you need in a form/subform arrangement, try

=Dlookup("[Customer]", "[Customer]", "[Customer]![CustomerID] = '" &
Reports!rptQuotesInfo!rptInquiryInfo.Report![CustomerID] & "'&quot

78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm