B
BHostler
I have created a sub form in my main form where I want my employees to be
able to type notes after contacting a customer. The fields I have in the
subform are Serial Number (which I have tied to the serial number of the unit
on my main form to link the subform to the main form), Date/Time, Contact
Name, Subject, Note Entered By:, and a memo box for the notes. In the
Date/Time field in design view I typed =Now(). This Automatically entered the
current date and time. The problem is I cant get it to lock that date and
time so after the note is entered it does not change. For instance if I enter
a note today it puts in the current date and time which is what I want. But
if I open the record tomorrow. The date and time change to tommorows current
date and time instead of showing me the actual time and date that the note
was entered. Znyone have any idea how I can fix this?
able to type notes after contacting a customer. The fields I have in the
subform are Serial Number (which I have tied to the serial number of the unit
on my main form to link the subform to the main form), Date/Time, Contact
Name, Subject, Note Entered By:, and a memo box for the notes. In the
Date/Time field in design view I typed =Now(). This Automatically entered the
current date and time. The problem is I cant get it to lock that date and
time so after the note is entered it does not change. For instance if I enter
a note today it puts in the current date and time which is what I want. But
if I open the record tomorrow. The date and time change to tommorows current
date and time instead of showing me the actual time and date that the note
was entered. Znyone have any idea how I can fix this?