You need to separate the 2 conditions with AND, plus the fields where the data type is text need to have delimiters, like
...Month = '" & Me.Month & "'"
More here on delimiters:
http://www.baldyweb.com/BuildSQL.htm
Sorry, I must be stuck on slow today. I thought I understood the info on Paul's website, but now I am getting a Type Mismatch Error. Thanks again for help.
Code:DoCmd.OpenReport "qry_Monthly_Production_Log", acViewReport, , "IssueYear=" & Me.txtYear And "Month = '" & Me.Month & "'"
Try
DoCmd.OpenReport "qry_Monthly_Production_Log", acViewReport, , "IssueYear=" & Me.txtYear & " And Month = '" & Me.Month & "'"
Thank you so much!!!!
Happy to help and welcome to the site by the way!