Refreshing the Screen after printing

[Azie]

I am printing an estimate off a form and then I would like to go back to the screen and print an invoice ...without typing in all the data again. The estimate has a distinct number and will also be the invoice number. Any suggestions would be helpful. I was looking for something like a refresh to a specific number. I appreciate the help...I am familiar with databases but not real familiar with Access

Thanks

 

[Sutto]

If the form is open could you add a command button to open the invoice on the form. Then in the docmd.OpenForm set the criteria so that it open at the invoice number as set by the form. You can setup a button of this sort using the wizard in Access2000

 

[Azie]

Thanks for the advise, I did find what you meant. I get an error message.....You cannot find or replace now. When the Invoice Prints it seems to do a save and put the form (screen) in add mode. Thanks Again...it sounded like it should work.