Adding event to a report

[ylivne]

Hi
I have a module I wrote. How can I add him as an event to the report?
I want the module to run every time I open the report.

Thanks
Yael

 

[SOS]

Hi
I have a module I wrote. How can I add him as an event to the report?
I want the module to run every time I open the report.

Thanks
Yael

1. You don't run modules. Modules contain procedures, which you do write, and execute.

2. It depends on WHERE you wrote this procedure as to where you can run it from. So did you put it in a STANDARD MODULE or is it in a form or report module?

3. You can, if the scope of the procedure is correct, run the procedure in the report's ON OPEN event by using

Call YourProcedureName

 

[ylivne]

1. You don't run modules. Modules contain procedures, which you do write, and execute.

2. It depends on WHERE you wrote this procedure as to where you can run it from. So did you put it in a STANDARD MODULE or is it in a form or report module?

3. You can, if the scope of the procedure is correct, run the procedure in the report's ON OPEN event by using

Call YourProcedureName

Hi
When I write "call MyProcedureName()" at the "On Open" field I receive a message that it is an unknown macro.
Where should I put my procedure?
I want it to run every time the report is opened.

I wrote my procedure at the Modules section and save it at the Module1 (STANDARD MODULE), and it goes like that:
Public Sub AllProducts()
...
End Sub

Thanks
Yael

 

[SOS]

Did you use

Call AllProducts()

 

[ylivne]

Did you use

Call AllProducts()

Hi
I played with it some more and found the answer

Thanks and have a great weekend.
Yael