How to have an field change on a different form when e-mailing?

[Leslie]

In my project update form there is a status field, at the time a 2nd form is
e-mailed from the database (this is a separate form linked to the project
update form by a project number assigned by the database) I want the status
field that is on the project update form to change to ECN issued. How can I
accomplish this? Can I use the forms!formname.fieldname.value="ecn issued?

Thanks in advance

 

[Klatuu]

Assuming it is the form's current record you want to update and that form is
open, yes; otherwise, you may need to consider an update query to execute.