Report Preview Command Button

[Steve Moss]

I have a form with a comman d button attached. The button has the follwoing
code in the On Click event.

If Me.Dirty Then
Me.Dirty = False
End If
DoCmd.OpenReport "Invoice Details", , , "[InvoiceID] = " & Me!InvoiceID

The code should Open/Preview the selected report, instead it prints the
report. This is good as it would be the next Command Butoon I was going to
attache to the form, but I still cant preview the report. Any suggestions


Cheers

Steve

 

[Rick B]

Try...

DoCmd.OpenReport "Invoice Details", acViewPreview, , "[InvoiceID] = " & Me!InvoiceID

 

[Steve Moss]

Brilliant thank you so much

Try...

DoCmd.OpenReport "Invoice Details", acViewPreview, , "[InvoiceID] = " & Me!InvoiceID


--
Rick B

I have a form with a comman d button attached. The button has the follwoing
code in the On Click event.

If Me.Dirty Then
Me.Dirty = False
End If
DoCmd.OpenReport "Invoice Details", , , "[InvoiceID] = " & Me!InvoiceID

The code should Open/Preview the selected report, instead it prints the
report. This is good as it would be the next Command Butoon I was going to
attache to the form, but I still cant preview the report. Any suggestions


Cheers

Steve