Open Report by Combo box

[rck3]

Ok, so as I figure out one issue I run into another but I am getting closer. Database is complete but I am working on reports. I have several reports complete which pull all data. I am now trying to include a filtered report and not sure where I am going wrong. Any help would be great!

I have a form created with a combo box that lists all options for a field PW_Filter. Once selected I want the report to open with it filtered showing only those that match the PW_Filter field. With the command below when I select an option from the dropdown it opens up an access window (instead of just opening the report) asking for the PW_Filter value. If I type in a value that matches my report opens fine, but I dont know why it is not passing the PW_Filter selection on instead of then asking for it to be entered. In the below my report is Time by Project Worksheet, Project worksheet is the report field to be filtered, and PW_Filter is the options in my combo box. What am I missing? Thanks everyone

DoCmd.OpenReport "Time by Project Worksheet", acViewPreview, , "[Project worksheet] = 'PW_Filter"

[June7]

Concatenate variables. Treat reference to control on form or field of form RecordSource same as a variable. Is PW_Filter also name of combobox?

DoCmd.OpenReport "Time by Project Worksheet", acViewPreview, , "[Project worksheet] = '" & Me.PW_Filter & "'"

Is [Project worksheet] a text field? If not, remove the apostrophe delimiters. Date fields use # symbol.

[rck3]

Thanks, I never did much in access before but understood programming in other languages. Just trying to get down those minor syntax issues. Works now and applied it to my other filters. Should be all set! You can mark it resolved.