Data mismatch - on report opening

[Egg 'n' Bacon]

Hi again :)

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)

[HansV]

What is the data type of the ID field? If if is a number (for example an AutoNumber field), use

DoCmd.OpenReport ReportName:="lblRecord", View:=acViewPreview, WhereCondition:="ID=" & Me.ID

The quotes Chr(34) are only needed for text fields.

[Egg 'n' Bacon]

Thank you kind sir, that was exactly what it was.