Post reply

open report with a different table source

  • March 18, 2014 at 2:25 pm

    #74252

    I want to open a report and use a different table that has the same fields necessary for the report. I tried this below but does not work.

    myReportName = "VendorVolume"

    sqlstr = "select * from [dbo_FactApHistory2015]"

    DoCmd.OpenReport myReportName, acViewReport, , , , sqlstr

  • March 18, 2014 at 2:57 pm

    #1698201

    I figured it out.

    Reports("mytable").recordsource = "Select * from mytable"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply