firing an access report from VB

I have a report in access that runs off of a query. The query prompts the user for a value for one of the fields. I need VB to run this report and insert the value into the query form when it pops up. Can this be done? Right now I click on report it fires off the report but gives me the message that access needs more info and gives me the option to switch to access and enter the info manually. Any ideas?:confused:

Change the report to run from a table, and build the table before running the report. You can populate the parameters into your query from VB, write this out to a table and then call the report.

HTH

or depending on what you want to do, you coudl just code your sequence in VBA in access since it seems that most of your work is being done from there!