Refreshing Question

  • Thread starter Thread starter Bunky
  • Start date Start date
Clif McIrvin said:
That default value of Now() is frozen at the instant the new record is
created ... from then on, any reference to that field will return that
value.

<Gotta go ... more later>
Click to expand...


....will return that
value.
Click to expand...

--- not the current time.

A slightly different approach might be to add

Me.DateofComment.Value = Now()

in front of

Me.Parent![Date Worked].Value = Me.DateofComment.Value

as appropriate.

It seems the fundamental question is, "What *exactly* does the timestamp
mean?"
 
Clif,

I created a records this morning... when I go back into it this afternoon
the Time will change. Now() returns Date/Time. The Date will only change
if I change the reocrd tomorrow. I use it in the Form_Dirty event of a
form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Clif McIrvin said:
Gina Whipp said:
Clif,

It will also change should you go back to that record and make a change.
Click to expand...

I'm a bit unclear here .... as long as the changes are uncommitted (ie,
before the Form's Before_Update event) there is only one Form_Dirty event,
correct?
Click to expand...
 
Back
Top