I have a button on my form that when you fill out all the information you press and it will save the information to the table and return the form to blank ready for the next entry. I also have a button that will send an email to the person filling it in with all the information on it so they have a record. So as it stands they have to press the email button then the submit button is there a way I can do this as one button so it submits the information to the table, returns the form to blank and sends an email? The submit button at the moment is done on a macro using the button wizard and save data and refresh.