automatic changing date

[taco]

Hi,
Probably this question has been asked before, but I'm new here. Don't know if the question should be asked here and hope that my English is good enough.

I have a database in which I change the content of the records on a regular base. There are two dates in it. One is the day I made/added a new record, one should be the date I made the last change, but I can't get it to work. I have been searching the Help-option in Access as well as Google to find an answer, but so far no results. I don't know anything about Visual Basic, so if you answer please keep it simple.

Taco

 

[RuralGuy]

You would put the time stamp in the BeforeUpdate event of your form:
Me.TimeStampControlName = Now()
...using your TimeStampControlName of course.

 

[burrcm]

The creation date of the record is best done at the table level using Now() as mentioned above as the default value of the column you establish for the purpose.

Chris B

 

[taco]

Thanks Chris, thank you too RG, but... I know where to find the BeforeUpdate part, but what do you mean with 'my' TimeStampControlName?

 

[stopher]

Thanks Chris, thank you too RG, but... I know where to find the BeforeUpdate part, but what do you mean with 'my' TimeStampControlName?

This is the name of the text box on your form that you are using to enter the date. So if you have called the text box LastChangeDate then the command will be
Me.LastChangeDate = Now()

Chris

 

[taco]

Ok that I understand! Thanks all of you, because it works now.

Taco

 

[RuralGuy]

Glad we could help.