Date infomation needed!

[lakattack]

Hello! I would like the date entered should automatically be entered when a record is created and also when looking back on that data it would show the date that it was added

E.g.

Today's Date 18/4/2006

Greatest Hits Album (CD1) added 10/4/2006
Greatest Hits Album (CD 2) added 18/4/2006

Can you help me?

Thanks

 

[rainman89]

you could set the date when u click a save button.. or anywhere in the form really

me.dateaddedfield=date()

 

[lakattack]

you could set the date when u click a save button.. or anywhere in the form really

me.dateaddedfield=date()

I wanna store the date that the CD was created on?

How do I do that?

 

[rainman89]

you mean the date that the cd was entered?
just like i showed u above.

 

[lakattack]

you mean the date that the cd was entered?
just like i showed u above.

Yes thats what I mean. Is is that code you showed me and where do I type that code?

 

[rainman89]

if you have a save button. you can put that in the onclick of the save button

 

[Rich]

Set the Default value to =Date(), no code needed

 

[RedRider279]

.

Great info! I was trying to put the "=Date()" in one of the actions in the Event tab and couldn't get it to work. Moved it over to the default value area and it works like a charm.

Thanks again

 

[rainman89]

red,
u cannot put that stuff into the event tab. the event tab is for calling vba or module actions through.