G
Guest
I have a subform that shows in datasheet view with fields Start Time and Stop
Time. These are set up to double click in field and date and time will be
entered to each. I need to set these fields so that once the time and date
has been entered, it cannot be changed, at least in front screen form view.
I tried searching previous posts and tried the following code:
on the current event of the form:
Me.ControlName.Locked = Not Me.NewRecord
And
On the After Update event of the form:
Me.ControlName.Locked = True
I can still click in the fields and it updates to the current time. Also,
with this being "new record", will the user be able to click to start time,
get out of the db, come back at a later time, go to same record and enter
stop time? We are using this as a time management tool.
Thanks in advance for any help with this problem!
Phisaw
Time. These are set up to double click in field and date and time will be
entered to each. I need to set these fields so that once the time and date
has been entered, it cannot be changed, at least in front screen form view.
I tried searching previous posts and tried the following code:
on the current event of the form:
Me.ControlName.Locked = Not Me.NewRecord
And
On the After Update event of the form:
Me.ControlName.Locked = True
I can still click in the fields and it updates to the current time. Also,
with this being "new record", will the user be able to click to start time,
get out of the db, come back at a later time, go to same record and enter
stop time? We are using this as a time management tool.
Thanks in advance for any help with this problem!
Phisaw