Access 2007: Help filtering a report query based on a form field

A

allin1joe

Joined
May 23, 2012
Messages
2
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report based on field criteria 2
Exporting a Report to Excel 2
Access Access Report Works on One Machine but not Another 3
Access prints form instead of report!! 4
Report based on a filtered form 2
Can't create a report from my query in Access 1
List Box to create a Report based on crosstab query 6
Open Report based on a drop down box 4

Top