default value date()

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christina - 30 Aug 2004 02:40 GMT

Hi, if you use the date() function as a default value in a
table, does it automatically update when you open the
table or actually modify a record? Is there a way to have
the creation date as the value, or a modification date
(I'm assuming both of these would require you to actually
edit the record in order for them to change). Thanks in
advance.

Reply to this Message

Allen Browne - 30 Aug 2004 02:51 GMT

DefaultValue applies only to the creation of the record, so you cannot use
that to record the modification date. Instead, use the BeforeUpdate event of
the form where edits are made:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[ModificationDate] = Date()
End Sub

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi, if you use the date() function as a default value in a
> table, does it automatically update when you open the
[quoted text clipped - 3 lines]
> edit the record in order for them to change). Thanks in
> advance.

Reply to this Message