How do I

  • Thread starter Thread starter theedge2k
  • Start date Start date
T

theedge2k

I have a form in which i placed a data field concerning HDD warranty date. I
need that control field to update the date with a 3 year period Ie, if i
enter 02-08-08 i want that control field to show 02-08-2013 in the box. I
apologized for the crudness of this question.
 
Realistically, you don't need to store 02-08-2013 anywhere, since you can
always recalculate it. Therefore, the best approach is to set the
ControlSource of the text box to

=DateAdd("yyyy", 5, [Forms]![NameOfForm]![NameOfOtherField])
 
I have a form in which i placed a data field concerning HDD warranty date. I
need that control field to update the date with a 3 year period Ie, if i
enter 02-08-08 i want that control field to show 02-08-2013 in the box. I
apologized for the crudness of this question.
Click to expand...

Douglas is correct if you want the warrenty date to always be five (three?
don't know which you intended!) years after the purchase date. If you want
the field to be editable - for instance, the default warranty period is three
years but you want to extend it for this customer - you can "push" the value
into the warrenty textbox in the AfterUpdate event of the purchase date.
 
Back
Top