Having The Save Button in the form pull the current date

[bd02eagle]

I have a form in access which Im using to enter data into a table. Well, when I click the save record button, Access saves the date in my Entry_Date field to the default date which is 4/20/1992 instead of the current date. What should I do?

 

[PHV]

You may try something like this in the BeforeUpdate event procedure of the bound form:
If Me.NewRecord Then Me!Entry_Date = Date

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886