help with locating public code

B

beto

I want to call the same public sub procedure from 25 different reports from
the 'on no data' property, but I can't get the code to work except by
putting the private sub procedure into each report. Where do I locate the
code as public?

Bob
 
D

Duane Hookom

Depending on what you want the code to do, you could place the code in a
standard module as function. You can then enter the function name in the On
No Data event.

On No Data: =YourFunction()
 
L

Larry Linson

I want to call the same public sub
procedure from 25 different reports
from the 'on no data' property, but
I can't get the code to work except by
putting the private sub procedure into
each report. Where do I locate the
code as public?
Click to expand...

In a standard module... in the Database Window, click the Modules tab, then
choose New...

Larry Linson
Microsoft Access MVP
 
Top