How do I have form bring in current date/time on focus?

[Amy Andersen]

I'm creating a form to input help desk issues. I want current date/time to
populate the field when new record is open. I also need for this date/time
to save with record and not update when record is reviewed (or opened again
for edits). Please advise. Thank you.

 

[PC Datasheet]

Open your form in design view and put the following expression in the
Default property of your date/time field:
Now()

The date and time will apeear when you first go to a new record but will not
be entered in the record until you make an entry in another field. This also
insures you have a date and time entered in every record. When you open
anexisting record to review or edit, since the date/time field already has a
value, nothing happens.

-
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

 

[Amy Andersen]

Thank you so much. Your instructions were perfect! My form works
beautifully, and we can track time of ticket opening. I may get to change my
hours if I can demonstrate a lack of tickets from 5 - 6 p.m. (and yes I'm
honest and will enter them even if they come in after 5 p.m. =) That's the
thing about data, it's only as good as the data enter-er. Thanks again;
you've made my life so much easier and now I'll be able to sleep tonight!