I have a request to embed a filter to open an Access report. I have created a new form with a combo box and the field to use. When I run my VBA command, I get a message "Enter Parameter Value". The note has the Selection in the Title area, but not the parameter box. If I enter the parameter manually, the report opens with that filter. If I remove the WhereCondition statement, the entire filter is bypassed. What am I missing?
Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click
Dim strRptName, strSelect As String
strSelect = "UID = " & cmb_NameList.Column(1)
strRptName = "rptHelpDeskReport"
DoCmd.OpenReport strRptName, acViewPreview, WhereCondition:=strSelect