E-mail problem

[Keith]

I have code behind the close button of a form that e-mails a report to head office. Can someone help me with a method of limiting the action of sending the e-mail to only take place if:
a)A new record is created.
b)A record is modified.
Thanks
Keith

 

[bvan]

You can tell if records have been modified or added by using the "Dirty" property in the code. You can use the condition:
if me.dirty then............