I have a very simple form that has a drop down and a button that calls a report. I want the report to filter based on the value in the drop down. Here's what I have:
DoCmd.OpenReport "PM Status Report", acViewPreview, , "[Area.DISPLAY_ORDER]=0 AND [Project_Resource.Resource_Type_ID]=1 AND [Project_Resource.RESOURCE_ID] = " & Combo0.Value, acWindowNormal
I added the Display Order and Resource Type to this string because I wasn't sure if having a WHERE clause in the query already was screwing it up. I have no issues with putting those back in the report query if it'll work that way.
The report is not filtering at all. I'm getting every record that the query produces. Any ideas on what I am doing wrong?
Thanks
Joe
DoCmd.OpenReport "PM Status Report", acViewPreview, , "[Area.DISPLAY_ORDER]=0 AND [Project_Resource.Resource_Type_ID]=1 AND [Project_Resource.RESOURCE_ID] = " & Combo0.Value, acWindowNormal
I added the Display Order and Resource Type to this string because I wasn't sure if having a WHERE clause in the query already was screwing it up. I have no issues with putting those back in the report query if it'll work that way.
The report is not filtering at all. I'm getting every record that the query produces. Any ideas on what I am doing wrong?
Thanks
Joe