auto date and time issue

[allyboy]

hi . I have a problem with now() function . I want access to fill in automatically the current date and time when I enter a new field . but the problem is when I start to fill in records in datasheet mode , access will enter the current date/time in the next new field instantly ! so when I am gonna fill the records in the new field later it has the old date/time in its date/time record . is there any way to solve this issue ?!

[ItsMe]

Where are you using the now() function? Are you using VBA or are you using the properties of the field @ the table or the properties of the control on the form?

A default value will display in the "New Record" when the dataset is retrieved. Maybe some code in an afterupdate event is what you are after.

[Bulzie]

Don't use Default value on that field, in the BeforeInsert event of form put Me.DateEnteredField = Now(). If you want this field to update each time the record is updated, put it in the BeforeUpdate event.