help with locating public code

  • Thread starter Thread starter beto
  • Start date Start date
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
 
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()
 
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
 
Back
Top