Append Query depending on check box

Hi Folks,

I'm after a piece of code which works as described below.

I have a save button on a form
I have a append query ready to run.

When the save button is clicked, I want the code to see if a checkbox is true or not and if its true I want the append query to run if its not then I want the form to save and nothing else. Anyone able to help??

Thanks in advance

Daniel

Append Query depending on check box