Problem filtering by fields in the subreport

[Jedi420]

Hello, I have a similar problem in that I have a Main report that displays all projects. Projects may or may not have status updates. I have a subreport in the main report that shows the updates (if any) per project. The sub-report shows the updateDate and the statusUpdate and is based off a table called tblProjectStatus. Now, sometimes I want to be able to open the report just using the date of updateDate from the subreport. So, I try to perform a

pubCriteria = "(tblProjectStatus.updateDate BETWEEN #6/1/2003# AND #6/30/2003# )"

DoCmd.OpenReport "Projects", acViewPreview, , pubCriteria

It prompts me for tblProjectStatus.updateDate and doesnt work. How can I get the Report to display all the projects but only the status updates within a specific date range. I'd be most appreciative of any advice or suggestions anyone could give. Thankx!

-Jedi420

 

[dhookom]

I believe this is the same thread I responded to but in the Access Reports Forum... I would recommend keeping only one thread going and being patient.

Duane
MS Access MVP