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

May 23, 2012
Reaction score
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?



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