Printing problem

Okay, I have a database in access. I run a query and after running the query it updates the query and places it in excel in a pivot table. I put in a command to print the pivot table and it prints, but it prints the previous quer, but shows the new query on the pivot table.

What am I doing wrong that I can't print the table. I can hit the print icon, but I'm trying to make it user friendly and press one button to run the query and print the form.

Help

hi you can use printer object in vb

so befpore thke the print jsut refresh .

it sove you rproblem
das