Auto Date of Input

[mpsDA]

Is there a way to have a Field setup to Automaticaly have the Date of Inputting appear into the field of a record.

 

[Pampers]

Before Insert Event of the form
Me.Field = Date

Pampers
Just let it go...

 

[PHV]

Have a look at the DefaultValue property.

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

 

[mpsDA]

PHV.
What would you type in the default Value?


PAMPERS.
Me.Date_of_Input = Date

Does not Work

Im and putting the code here.....

Private Sub Date_of_Input_BeforeUpdate(Cancel As Integer)
Me.Date_of_Input = Date
End Sub

 

[PHV]

What would you type in the default Value?
=Date()

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

 

[Pampers]

in the default value of the control/field you put: =Date()

for the event to occur, it has to be in the before insert event of the form, not the field.

Pampers
Just let it go...

 

[mpsDA]

OK it does bring in the current date but when goin backk to the record it changes to the current date each time its opened for axample if i was creating a record on the 1st of May...it will display the 1st of may into the field.

When i open it the following day it will replace the date with current date.

Do i need extra coding?

 

[Pampers]

I think you have to bind it to a datasource; it looks like it is an unbound control now.

Pampers
Just let it go...