Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Record Source (Access 2000)

    Can i define the record source of the report in the command line opening the report ? I know how to place the record source in the OnOpen event of the report but i do not know is it posible to do it in the command line:
    DoCmd.OpenReport "R1, acPreview, , "" Reports! R1.recordsource = "qry1"
    Unfortunately the above command line is not accepted by Access.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Record Source (Access 2000)

    As far as I know you cannot do it there. As you said it can be done in the OnOpen event of the form.

    Why do you want to do it on the command line of the OpenReport?

Posting Permissions

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