Okay! Progress!
I've done some reworking of the fields, and I've got it working like this:
Code:
DoCmd.OpenReport "GetOrgInfoRep", acViewPreview, , "OrgArtsCultureC = '" & Reports!EngageSelectedYPRep!YPArtsCultureC & "'"
Can you please tell me how would I add an additional one to it with an "OR" connection?
Something like
Code:
DoCmd.OpenReport "GetOrgInfoRep", acViewPreview, , "OrgArtsCultureC = '" & Reports!EngageSelectedYPRep!YPArtsCultureC & "'" Or "OrgBusinessC = '" & Reports!EngageSelectedYPRep!YPBusinessC & "'"
When I do it like the above, I get a type mismatch -- I double-checked all the calculated fields, and the "Result Type" is Text for each.
Thank you, thank you, thank you -- I cannot believe that I am seeing a light at the end of this looooooooooooooon tunnel!!
--ak