APDATE DATE FROM ONE FORM TO ANOTHER

[MICHELE]

I have a form and a subform. I want a date from the subform to be updated with a date from the main form if a condition of another field on the main form is met.

If New Job = "Y" Then Ship to Amt will update to JOBCONAMT

Where and how can I write this?

 

[MICHELE]

I thought about linking the fields, however, I don't want the 2 field amounts to always be equal to each other. The amount in the field of the parent table will change while the amount in the field of the child table will remain the same. When the record is added in the child table, that will be the only time the field amounts are equal.