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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top