Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sydney, Australia, New South Wales, Australia
    Posts
    251
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Report function calling another report's function (Access 2000 VBA)

    Can a function in one report call a function in another report? I was thinking something like:
    Total = [Reports]![r Activity]!TotalIt(1,2)
    But that doesn't work. I know I could hive the function off into a module, but for my application it makes more sense in a report.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report function calling another report's function (Access 2000 VBA)

    In theory, probably, but reports aren't interactive the way forms are. What exactly are you trying to accomplish.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    Vermont
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report function calling another report's function (Access 2000 VBA)

    You're very close, at least in my experience. Try:

    =[Reports].[r activity].TotalIt(1,2)

    The only kicker is that the [r activity] report must be open and in preview view for the function to be accessible.

    Jordan

Posting Permissions

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