report generation

Hi
my database is in access..and front end is vb....i want to create reports in access....if i do this how can i link these reports to my vb form.....and is there any drawback of making reports in access and using thm through vb form......i need advice
thnx

Moved to reporting section.

Create your reports in Access.

To call them from VB, set a reference to the Microsoft Access X.X Object Library (where X.X is the version installed on your machine.)

Then, use code like this:

VB Code:

Private Sub cmdPrintReport_Click()
          Set Axs = CreateObject("Access.Application")
           Axs.OpenCurrentDatabase (DBPath)
           Axs.DoCmd.OpenReport "MyReport"
           Set Axs = Nothing
           Axs.Quit
End Sub

Where MyReport is the name of the report that you have previously created in Access.

I don't see drawbacks. I've used Access reports from VB before with great success.