Hi James

Definitely doable. for the Email portion, check out  Access Email Seminar
For Auto generate an Invoice, you need to trigger that from AfterUpdate event on where the "Completed" is triggered.

This will require quite a bit of VBA.

oh okay, Sami. I will start digging into it and see what I can come up with.