Textbox in an Update Form

  • Thread starter Thread starter Nora
  • Start date Start date
N

Nora

I have 2 text boxes in my updatable form that I want ask about.
1st one is "Register Date" and the other is "Actual Date".

How can I create the "Actual Date" to run my code before I go to another
text box to input other data (this is a a NEW RECORD page of the form)?
The code is: IIf([Register Date] = Now(), [Register Date], "")

In the same time, I want the "Actual Date" remain unchange for all the
previous records. And also, I want the "Actual Date" to update the linked
table after I accepted the data displayed in the "Actual Date" after it run
my code.
 
The code is: IIf([Register Date] = Now(), [Register Date], "")
Not going to happen, ever!
This Now() --- 11/9/2009 1:19:52 PM but in two seconds it will be
11/9/2009 1:19:55 PM so your [Register Date] just ain't gonna match.
 
Back
Top