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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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!
 
Back
Top