<jj****@earthlink.net> wrote in message
news:ZC*****************@newsread2.news.pas.earthl ink.net...
how can i make it so that when the value of one field is 15 another field
in same record automatically enters todays date? thanks in advance!!
If you mean, automatically, in a table, without anything else happening, you
can't. Perhaps if you'd tell us a little more detail -- when do you want
this to happen, when you are entering data, or to records that already
exist, etc., we could be of more help.
If you are entering data in a form, in the AfterUpdate event of the Control
where the "15" would appear (call it txtTest) , you might code the following
to set today's date in another control (call it txtNewDate):
If Me!txtTest = 15 Then
Me!txtNewDate = Date()
End If
Larry Linson
Microsoft Access MVP