insert current date in field on form

J

JohnJ

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
 
G

G. Vaught

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
 
Top