Locking Records

  • Thread starter Thread starter Pam
  • Start date Start date
P

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