After a click in a chackbox I need the current date/time

[Dimitris]

Hello
In a table I have these fields: Answer1, Answer2, Answer3 and also 3 check
boxes: Time1, Time2, Time3. What I need from the form is when someone clicks
on the checkbox Time1 the Text Box Answer1 to fill in the current date and
time. That is the time of the click. The same with the checkbox Time2 and
Answer2 and Time3 with Answer3.
Can someone help?
Thanks
Dimitris

 

[Douglas J. Steele]

I hate to say it, but your table doesn't sound as though it's properly
normalized. What happens when you get a fourth question whose answer you
need to record?

You really should be using a second table that stores AnswerNumber, Answer
and Time (plus a foreign key to link it to the original table), so that
you'd have 3 rows for your current setup.

In any case, in the AfterUpdate of the checkbox, put code to set the
textbox's value to Now.