Sending a Value from VB Module to a Report in Access

[mgarces]

I need to know if you can pass a value from a VBA window directly to a report in Access 2000.

In other words, not assign the report a control source. Just pass the values from the module directly.

Normally I would send the info to a table first and then build the report from the table, but I wonder if its possible to do a direct transfer.


Thanks

 

[SiJP]

At a guess I'd say declare a global variable, pass the value to this variable, then use it from the on_open event of your report....

------------------------
Hit any User to continue