Textbox in an Update Form

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.
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top