Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Capturing "NOW" in a field

Status
Not open for further replies.

jdd3110

MIS
Dec 11, 2003
18
US
I am creating a form for a database at work and I would like to autopopulate the "date" field with the date and time that the record was saved. Is there any way to capture the now function? Thank you very much
 
Me![controlname] = Now()

willcapture the now funtion result.....you just have to determine where to use it.....place it in a save button or whatever and you shoudl be set.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top