Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Sep 2003
    Location
    Houston, Texas, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sub report recordsource (Access 2000)

    In the past I have been able to set the recordsource of a report depending on how I reach the report or what chocies have been made before the report is run. It works great. Now I need to set the recordsource of a subreport and am getting error messages:
    If I try to change the recordsource in the subreport I am told that you cannot change the recordsource once the report has strated printing. That makes sense.
    So, I tried setting the recordsource in the main report and get the following error message:
    See attached Word doc. I am showing the code in the same document.

    Thank you for any help!

    deutsch
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sub report recordsource (Access 2000)

    You must ensure that the record source is only set the first time the On Open event of the subreport fires. See HOW TO: Set Subreport's RecordSource Property at Run Time in Access 2000.

  3. #3
    Star Lounger
    Join Date
    Sep 2003
    Location
    Houston, Texas, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sub report recordsource (Access 2000)

    That did it. Thanks, Hans!

Posting Permissions

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