Error trying to print

[koncreat]

I created a button on the Invoices form and it should show a print preview of the current record. However i am getting an error when i try.

[ranman256]

your invoice# are strings so put delimiters in the code:

DoCmd.OpenReport "r_invoices", acViewPreview, , "[invoice]='" & Me.invoice & "'"

had the field been numeric, your code would have worked.

[koncreat]

That did it! Thanks!