Add Date to data when it is typed in the database?

[lakattack]

I would like to include the facility to add the date when a new CD is added to the collection. The date entered should automatically be entered when a record is created. Relevant forms should be amended to reflect this new requirement!

I have attached my database so that I would hope it would be easier for you to help me!

Can anyone help me please!

Thanks!

 

[boblarson]

just set the Default property of the text box that is bound to the date field as:

=Date()

That will add the current date for a new record but not change existing ones.

 

[lakattack]

just set the Default property of the text box that is bound to the date field as:

=Date()

That will add the current date for a new record but not change existing ones.

Well in the database I would like a person to add a new CD and the date they added the CD would be there. Eg. CD1 was added 18/4/2007, CD2 was added 10/4/2007

How I would like it would show up:

Cd Title Date Added

CD1 18/4/2007
CD2 10/4/2007

So everytime a person looks at it the date would stay the same and only change if a CD is being added.

Is your way the way to do it or is there another way?

If so please tell me!

Thanks