I have a query that asks for input from the user (Customer PO number). This is used to create a form where a customer service person can find out what's been ordered, shipped, etc. by the PO number. What I need to do is transfer that information to a report format. Since the input is done in the query, when I compose a macro to run a report based on the query, Access requests that the Customer PO number be re-entered. How can I get around this?

Thanks, in advance, for your help!

I would make a form with a combo box on it containing all of the Customer PO number in it.

Then make another query identical to the first except that in the criteria for the Customer PO number is the combo box on the form.

On the AfterUpdate event fire off the macro and the right report should print.

If you need a sample let me know