I am trying to run a DoCmd.OpenReport for a command button click:
DoCmd.OpenReport "ReportName", acViewPreview, , "[FIELD_NAME]=" & Me![ComboBoxSelection], acWindowNormal
I get the Syntax Error (Comma) in Query Expression with the Combo Box Selection equal to Last Name, First Name. Is there a way to rectify this?