notification button

I have made a access database for our school systems website.

It is a work order database. The technology contacts at each school fill out an asp form with contact and problem info and it loads it as a new record in the database. We have results pages for each school setup sot that if a teacher wants to verify that the workorder is there they can view all open workorders for that school. I have a database editor page so I can manual add, edit, or delete records.

What I want to do is this. Everytime one of our techs completes a order I want to be able to select the record with a check box and hit a command button that will email the contact person (Each record has a contact email field) saying this workorder is completed. Then the tech can simply delete the record

Any suggestions?

You could do this as a form, with an asp to handle it. The form would have the checkbox, and maybe a text box for any comments the tech wants to add in the email to the contact person.
When the 'submit' was pressed, then the asp would open the db, pull the email address, and send the email.
The asp could also be set up to delete the record at the same time, or let the tech do it afterwards.
I think this can also be done w/ PHP, but I only know asp, so thats how I would do it.
HTH
Dave