getting a module to build a table then have a report print

[Guest_imported]

I built a module that will build a newtable that consists of severalfields from an old table. the module works. I then created a query that accesses this new table and several other tables. when I run the report how do I get the report to access this module. I have tried calling it from the event procedure option when the report opens but I recieved an error that item is not a module.

thanks,

 

[MichaelRed]

Doesn't compute. Please post the part of the code which generates the error, the exact and complete error, and at least the header of the procedure which you are attempting to call.

At least part of the confusion - on this end - is the attempt to call a "MODULE". Modules are just containers. They cannot be 'called'. Their contents are "procedures" (Sub | Function). These are the "procedures" which are 'called' from other 'procedures'.


MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over