DateAdd function for SubForm

  • Thread starter Thread starter jacecrocker
  • Start date Start date
J

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
 
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.
Click to expand...


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

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