A
Abbey Normal
Hi I have a report which also prints another report within it.
I print the report initally from a form creates the criteria string, which
looks like this:
current = true and SKU = '12345678' or SKU = '23456789'
So when I click on print to print the report, it does this:
stWhere = Criteria
DoCmd.OpenReport StDocName, AcNormal,,stWhere
[this report has a record source of qrySpec]
My report-within-the-report, has a record source of qrySpecAuditLogs, which
looks like:
SELECT TOP 1 Auditlog.sku, Auditlog.reason, FROM AuditLog
WHERE AuditLog.sku = '06366036'
ORDER BY AuditLog.chgdate DESC;
Is there any way to change (qrySpecAuditLogs) so it can use the same
criteria that I created above? Perhaps I could do it before it performs the
DoCmd.OpenReport?
Thanks for your help
I print the report initally from a form creates the criteria string, which
looks like this:
current = true and SKU = '12345678' or SKU = '23456789'
So when I click on print to print the report, it does this:
stWhere = Criteria
DoCmd.OpenReport StDocName, AcNormal,,stWhere
[this report has a record source of qrySpec]
My report-within-the-report, has a record source of qrySpecAuditLogs, which
looks like:
SELECT TOP 1 Auditlog.sku, Auditlog.reason, FROM AuditLog
WHERE AuditLog.sku = '06366036'
ORDER BY AuditLog.chgdate DESC;
Is there any way to change (qrySpecAuditLogs) so it can use the same
criteria that I created above? Perhaps I could do it before it performs the
DoCmd.OpenReport?
Thanks for your help