I'm hoping to open a report (from a form that shows single records) showing only the current record.
I can open the report with all records, but when I add the WhereCondition I get "Data type mismatch in criteria expresssion" error
The line of code =
Code: Select all
DoCmd.OpenReport reportname:="lblRecord", View:=acViewPreview, WhereCondition:="ID=" & Chr(34) & Me.ID & Chr(34)