Richard,
I have data that I am importing from an excel file. The import process has been saved and I have written a query to massage that data once it is imported so that I can append it to one of my tables. After testing that process and found it accurate, I have turned it into an append query and automated it in code.  I have also written code to ask the user if that  source excel file has been updated before continuing.  All that works fine but I am wondering if there is some way to have a "preview" pop up of that data so that the user can verify authenticity before the actual update occurs?  Can I create a report that would pop up before the append process happens and put that in my code?

---

Reply from Richard Rost:

Sure. Have a form pop up so they can review the imported data, and put the button to continue with the next step at the bottom of that form.