I know this is a simple function but I am not very ACCESS savvy and it has been a while since I have programmed this function. Using '97 I need to set up the code so when I make an update to a certain field, I different field automaticly updates with today's date. Any thoughts!!??
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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Making a date update based on chnages in another field
- Thread starter Eltoque
- Start date
alistairpaul
Programmer
You should be able to make this or something like this work:
Private Sub text1_AfterUpdate()
Text2.Value = Now()
End Sub
Put that code into your Form's code module, and change the "text_1" part of the Sub's name to the name of your control of the value you'll be changing. Then replace the "Text2" part of the statement to the name of the control where you want to store the date. Then you'll have to format your date however you want to.
Private Sub text1_AfterUpdate()
Text2.Value = Now()
End Sub
Put that code into your Form's code module, and change the "text_1" part of the Sub's name to the name of your control of the value you'll be changing. Then replace the "Text2" part of the statement to the name of the control where you want to store the date. Then you'll have to format your date however you want to.
- Status
Similar threads
- Locked
- Question