Locking Records

[Pam]

Hi,

I am looking for a way to lock, hide, or remove records from datasheet view.
I have a subform in datasheet view set up as follows:

Tech StartTime StopTime WorkCode Comments

The tech name is a combo box. Start and Stop Times are set to Now() when
double clicked. Work Code is a combo box and comments is a memo. The
problem I'm having is that users have figured out that they can overwrite
the start time by entering new time exactly as it shows when clicked. I
have put Enabled/Locked coding on the form's CurrentEvent, but if the cursor
is on a new record, the user can still go to a previous row on the datasheet
and change the time. Is there a way to prevent this? I have spent
considerable time in the forms and forms coding posts and have tried code
listed there, but am still having the problem with going to a new record.
Any help is appreciated!!
Thanks,
Pam

 

[Allan Murphy]

Pam

On the properties for each field set the Enabled to YES and Locked YES or
you can set Enabled to NO this will give a grey background.

 

[Pam]

Allan,

Thank you for replying. I have tried this and it still didn't work as I
expected for datasheet.
User can still open a new record and change the date in a previous record by
clicking on that field.
I worked around the problem by changing the form to single view and did a
visible/not visible coding to remove the field. Thanks again, Pam