Jim,
What your saying makes sense, but could you be a little more specific? Ultimalately I need the command button to do the same function with 1 minor change. If the box is checked I need to add an email address to the CC portion. Where would I put the Dim statement, and what recognizes if the box is checked or not?

Thanks to all of you for your assistance! This is a great site, and I'm glad I found it!

I tried to combine them, but it still didnt work. Do I have to set the values or properties of the check box somewhere that I might have missed???

I have been tasked to create a 'simple' form in Access providing managers to input necessary changes. I have 2 command buttons on the form and a check box. Command button 1 updates my table for multiple entries, and command button 2 e-mails the table in HTML format to my team, appends the data entered to a back-up table, and deletes the entries on the current table.

When the check box on my form is checked (indicating a permanent...