Preview Closing as Soon as It is Loaded

[Grezzo]

This code works fine to preview an invoice in Access2003, but not in Access2000.
DoCmd.OpenReport "Invoice", acViewPreview, , "Invoice.InvNumber = Forms!Invoice!InvNumber"
In Access2000 it just opens then closes as soon as it is open.

Any ideas why and how to get it working right with both?

Also just found out that this code:
DoCmd.OpenReport "Invoice", , , "Invoice.InvNumber = Forms!Invoice!InvNumber"
Also doesn't work, it brings up the printing message, then nothing goes to the print queue

Cheers

 

[WayneRyan]

Grezzo,

DoCmd.OpenReport "Invoice", , , "Invoice.InvNumber = " & Forms!Invoice!InvNumber

Wayne