We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

assign a calculated value to a form field [closed]

asked 2012-08-04 12:26:08 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

My table has a Date/Time Stamp field. I can't figure how to have the date/time stamp field update automatically. I tried entering the default value as now() But when I click away from the field in the design view the now() disappears. I created a form and for the field property I again tried entering the default value as now(), same thing, it goes away when I click away from the default property field. I created a function getnow() that returns the now() value i.e. function getnow() getnow = now() end function I assign this to an event such as mouse enter. No use. Generally, how can I both use a value from a field in the active record in a form and conversely how can I assign a fucntion or a procedure value to a field in the active record in a form? Please help Thank you

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 12:36:12.785919


@Alex Kemp, I have the exact same question. I am moving form MS Access and have a Date/Time field called "Created" that I want to automatically timestamp. In Access I could put =Now() for date and time, or =Date() for just date. I can put 0 or 1 in the Default value box, so I know it's doing something, but when I click F1 for help there is no help on this. The only note is the one in the right hand box, "Enter a default value for this field. When you later enter data in the table, this st.

EasyTrieve gravatar imageEasyTrieve ( 2016-11-02 10:11:03 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-03-06 12:07:25 +0200

qubit gravatar image

Hi Anon,

Are you asking how to insert a current timestamp whenever a new record is added via the form?

edit flag offensive delete link more

Question Tools


Asked: 2012-08-04 12:26:08 +0200

Seen: 772 times

Last updated: Mar 06 '13