Enet 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

[RuralGuy]

Reports have an Open event.

[ylivne]

Reports have an Open event.

yes, and when I write "call MyModule()" at the "On Open" field I receive a message that it is an unknown macro.
How should I define my procedure?

Yael

[RuralGuy]

You can not call a module in Access but you can call a SubRoutine that resides within a standard module. The Sub must *not* be named the same as the module name.

[ylivne]

You can not call a module in Access but you can call a SubRoutine that resides within a standard module. The Sub must *not* be named the same as the module name.

I did call my sub routine (not the module), and I did give the routine a significant name.
My procedure is defined in the module like that:
Public Sub AllProducts()
...
End Sub

At the report properties, at the On Open event field I wrote:
call AllProducts()
and received a message telling me the macro AllProducts() is unknown.
How should I define my procedure?

Yael

[RuralGuy]

You need to use code. On the event tab, press the "..." button in the OnOpen row and select "code".

[RuralGuy]

When you are done the OnOpen row should have [Event Procedure] in it.

[ylivne]

When you are done the OnOpen row should have [Event Procedure] in it.

Thanks, that is what I did not know.
Now it is working!!!

Have a great weekend.
Yael

[RuralGuy]

That's excellent! You have a great weekend as well.

[RuralGuy]

BTW, is this thread ready for the Solved thread tool now?

[ylivne]

Yap

I did not know about this tool...