insert current date in field on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a donation and date field. I want to be have the current
date entered auto when an amount is entered in the donation field. Using
Access 2002
 
In the field on the form where you enter the donation amount set an Event
for the After Update and type something like this. Replace your field name
for the date of the donation in the place of mine. So if your field name was
DonationDate, just change my TodaysDate to that value.

Private Sub Donation_AfterUpdate()
TodaysDate = Date
End Sub
 
Back
Top