View Full Version : Date Field Change


jumpingjackjohn
07-08-2001, 05:24 AM
In my form i have two fields each one is called datein - dateup.
In my tables i have
format = long date
inputmask = 99:00:00:\>l\t;0;_
default value = Date()
For the two fields, datein & dateup.

This is good for datein.
But as for dateup, when someone opens a customer file, i would like for the date to change to the new date ( todays date ).
is this possible,

please help.


Thank You.

jstutz
07-09-2001, 11:18 AM
You can use the OnDirty event of the Customer form to update the DateUp field when someone changes any info on the form. It's would look like:

Private Sub Form_Dirty(Cancel As Integer)
Me.Dateup = Date()
End Sub

js

[This message has been edited by jstutz (edited 07-09-2001).]