Fill in Date Automatically

NoSmoke

Registered User.
Local time
Today, 07:20
Joined
Nov 10, 2012
Messages
99
I would like to have a date control on a form filled in automatically with the current date when a new record is created (the date would remain as is unless changed manually). I've tried programming it in VB but, being a newbie, have not been able to come up with anything that works. I'm not even sure how to trigger an event to do it just the one time when the record is created.

Could anyone please help me with this?
 
No VBA required here NoSmoke, just set the default value of the field to =Date()
 
Thanks much Isskint - who knew it would be so easy :D
 

Users who are viewing this thread

Back
Top Bottom