Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    233

    Unanswered: get record source of subreport

    i tried:
    strSubSQL = Reports![Credit]![ByCompany].Report.RecordSource

    but this doesnt work,

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    You could always save the .Recordsource to a query and then...
    strSubSQL = "myQueryName"
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •