C'mon guys - please help me with this before I bore you to death with it!!!

I have a function in an Access 97 database, which I run via a macro.

I want to print some values directly from this function to the printer. Can I do this?

If I can then I can't seem to find a way! If not then do I have to create a temporary recordset and use a report to do my printing?

Can I get hold of the printer object?

This (apparently) simple problem is driving me crazy!!!

Thanks in advance