DateAdd function for SubForm

[jacecrocker]

I have a form with a 2 tabbed control. First tab has a subform and a
subsubform. Second has a subform.

I want to take the number field[FreightDays] on the main form and add
it to the date field[Shipped] on the subsubform to create ETA. I
understand the DateAdd function but not quite sure how to accomplish
this.

Thanks,

Jace

 

[Marshall Barton]

I have a form with a 2 tabbed control. First tab has a subform and a
subsubform. Second has a subform.

I want to take the number field[FreightDays] on the main form and add
it to the date field[Shipped] on the subsubform to create ETA. I
understand the DateAdd function but not quite sure how to accomplish
this.

You can use a text box expression to display the ETA using
an expression like:

=DateAdd("d'", [FreightDays] +
subform1.Form.subsubform.Form.Shipped)

 

[jacecrocker]

Thank you!

Jace