Ok, so I'm still tweaking that database I made for the people on the other installation. They asked me if I can get it so that when the user within the database sets the status of the task to "closed" that it asks if the user would like to send an email to the person who was notified to pick it up uupon completion.
So i guess what I have to do is figure out a way to check the status within the 'status' field and when it is set to 'closed', put a dialog box out that says , " Would you like to notify the user that their task is completed and ready for pickup "? (yes/no).
If they select yes, it opens a form that I made for sending the email and automatically pulls the email address from that user from the main form, they then type in their message and send it off.