I want to print an Access 97 report in VB6. The report is based on a query which takes one parameter.

At the moment, Access prompts me for the parameter. How can I give the query the value of the parameter using VB code? The value of the parameter is held in a variable which was determined earlier. I don't want any user interaction during this process.

I am using VB6, Access 97, and Jet/DAO.

Thanks in advance.

[This message has been edited by Michael (edited 06-23-1999).]