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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top