Accept code date and Manuel date?

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

Guest

I have the following code in my text box to populate and store the date for 3
weeks out. However if the user needs to change the date manually it reverts
back to the code (populated date).

How or what do I need to be able to use it both ways? the populated date and
or the manuel date? Here is the code in the text box whcih populates it date
+ 3 weeks into another text box.

If IsDate(Me.LoanApplicationPackageReceiptDate) Then

Me.ZoningDue = DateAdd("ww", 3, LoanApplicationPackageReceiptDate)

End If
 
If I understand the question correctly, and you don't want the ZoningDue to
be updated incase it already been manuly entred, then try

If IsDate(Me.LoanApplicationPackageReceiptDate) And IsNull(Me.ZoningDue) Then

Me.ZoningDue = DateAdd("ww", 3, LoanApplicationPackageReceiptDate)

End If
 
Its close however the 'LoanApplicationPackageReceiptDate" date may or maynot
be null. same goes with the 'zoningdue' field. they just want to change the
zoningdue filed if it needs to be chaged for some reason.

thank you
 
Back
Top