I have a form where the report is completed then at the click of the email button the report is emailed. What I would like to do is add a section of code to the email button that will update the form before the report is mailed.
Thank-you
Cheeco
I have a form where the report is completed then at the click of the email button the report is emailed. What I would like to do is add a section of code to the email button that will update the form before the report is mailed.
Thank-you
Cheeco
Update with what? To change a value:
Me.TextboxName = DesiredValue
I want to update the form using the email button before the report is sent out by email.
What exactly do you mean by update the form?
What is happening now pbaldy is if the user clicks the email but with out saving first the report is blank when it get emailed. What I am asking is the when the user clicks the email button the the report gets saved first then the report gets emailed out. So what I am looking for is a piece of code to put in the email button before the send email command that will save the report first then email the report. I am sorry that I have not been very clear on what I am asking for.
That worked great Thank-you