Data type mismatch

[Bartk]

I have a database that you input data in on a form and then I can open a report which will show several entries within the database. Within the report off to the side of the entry I have a button with an embedded Macro which when I select it I want it to bring up the original form with all the information on the form.

I have the following error after I select the button:
Runtime Error 3464
Data type mismatch in criteria expression.

When I drill down into the embedded macro this is what I have for the following:

Private Sub Command29_Click()
DoCmd.OpenReport "Report1", acViewReport, , "Citation = '" & Me.Citation & "'"
End Sub

Any thoughts would be appreciated. Thanks in advance

 

[xenou]

Hi, what's the datatype (and expected value) of Me.Citation

Since that's a button on your report, it should be a field on your report somewhere, I guess - and it should be single field containing one value (as opposed to some kind of field in the report that could have many rows of values).

Though since you say the report is opened from the form, I don't quite see the need to open (?) the already open form (?).