Printing a report

[kaku]

I have developed a VB application for my project with MS Access as a database.

I have design an invoice report in Access and want a button to call and print it in VB. How should I go about it, please advise me thanks.

[hjozinovic]

Hi,

You can do this:
1. add a new button somewhere on the form.
2. Go to VB and in it's On click event put a code like:

DoCmd.OpenReport "ReportName", acPreview

You can search help on "OpenReport " to learn more about how it works...

h.