Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
form basics
- Thread starter snowolf
- Start date
Pipewelder
Technical User
Set the default value of the field in the table to now() or the before update or form current event procedure of the form can set the value in the text box.
Private Sub Form_BeforeUpdate(Cancel As Integer)
if IsNull(the_field) Then
the_field = Now()
End If
Many other methods can be used. Here is how I would do it. It depends on your application.
Private Sub Form_BeforeUpdate(Cancel As Integer)
if IsNull(the_field) Then
the_field = Now()
End If
Many other methods can be used. Here is how I would do it. It depends on your application.
- Status
Similar threads
