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

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote