Time Stamp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have form that I would like to add a time stamp to. Currently, I have a
field set up so that when the user tabs to the field and tabs out it
automatically stamps the current time. However, when I close out of the form
and open it again, the time updates itself with the new current time. How can
I get it where once the time is stamp on that record, it does not continually
update itself? Also need the same advise for dates as well. I want to make
sure the date doesn't update everytime you click on the record.

Here's another suggestion: This form has a subform. On the main form when a
selection from the drop down is chosen(on click) is there a way I could get
the date field and time field automatically fill in the subform? Again,
without updating itself everytime the user goes to the record?

Thanks to all for your expertise and support.
 
What you would normally do is write a timestamp using code when a record is
added, or when one is changed. You might also do it when a button is
pressed.

In your code, you need to include an IF statement that says "if the field is
blank, then write the date..."

Smarten up your code a bit.

For details on how to set up timestamps, do a search and read the previous
posts on timestamps.
 
Just check to see if the fields that date and time you want to stamp are
null. If they are, stamp them, If not, leave them alone.
 
Back
Top