Can Access be programmed to close itself?

[dunc723]

A user needs to get a new document number from a table, which is then inserted into a new Excel file. I have most of this worked out - the user clicks a desktop icon, which opens a simple Access database; a form automatically opens and gets the next document number from the table; the user populates three other fields and clicks OK; the record is saved, the Excel template is opened and the document number inserted in the appropriate cell. (If this sounds familiar, I posted a question last week on how best to make all that happen, but I have worked this much out.)



The final step: Instead of the user having to close the database (or potentially forgetting to close it), it should close itself and exit. Is that possible?

Thanks!

[Bob Fitz]

Try:
DoCmd.Quit

[dunc723]

I knew it had to be something simple! Thanks for your quick and direct response.