Am I entering the Me![NameOfControl] = Time as the defualt value or the
validation rule in the design view of the table? Or do I need to figure out
the "name of control" in order to make this work?
"fredg" wrote:
On Tue, 24 May 2005 20:18:01 -0700, hiteckchick21 wrote:
I am trying to create a time and attendance form. The form itself has the
employees demographic information and the subform is where their entry
records will be. I do not want the employees to have to physically enter the
actual time I want the time to be entered in the field when they select it.
ie: when the employee has to enter their beginning lunch time they just
double click in the field and the current time will be generated.
I was able to set the default value of the date to Now() to keep the date
current but I need to do the same for the time wih out all fields generating
the exact some time. HELP!!!!
Set the control's Format property to a valid Time format.
Code the control's Double-Click event:
Me![NameOfControl] = Time
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
|