"Lori" <L***@discussions.microsoft.com> wrote in message
news:ADC851AF-EC60-41C7-AD41-F66CCD234504@microsoft.com...
> My database is finally getting ready to go live for my company and I have
> a
> couple of security issues.
>
> 1. I have employee evaluation forms set up in the database. Is there a way
> to restrict viewing of a specific entry to only certain people (example:
> Laurie, her boss and Senior management should be the only ones with access
> to
> Laurie's evaluation and Laurie should be the only be able to edit one
> field
> in this form) is this possible?
>
> 2. Finally, I know its possible to prevent editing once a form has been
> completed  by allowing imput but no editing but is it possible to recreate
> a
> button or field that once clicked or checked will lock the form so it
> cannot
> be changed? The evaluation form is several parts and the reviewer and the
> reviewee both need to enter in their portions but it needs to be locked
> once
> completed.
> --
> Lori A. Pong

"John Welch" wrote:

> Lori - about the second part:
> I'm assuming that you don't want to lock the form as a whole, but just a
> particular record displayed in the form.
> You could have a yes/no field in the table called "lockme" or something,
> with a corresponding checkbox control on the form. The default value of the
> field would be no (or false). Then in the after_update event of the
> checkbox, you could say:
> if me.chkLockMe = true then
>   me.allowedits=false
> end if
>
> In the Current event of the form, you would say:
> me.allowedits = not me.chkLockMe
>
> This would make it so that once the checkbox was checked, you couldn't edit
> that record any more via the form, but it wouldn't stop anyone from editing
> the record directly from a table or query (or a different form based on the
> same info.), so you would have to prevent those things from happening.
> -John
>
> "Lori" <L***@discussions.microsoft.com> wrote in message
> news:ADC851AF-EC60-41C7-AD41-F66CCD234504@microsoft.com...
> > My database is finally getting ready to go live for my company and I have
> > a
> > couple of security issues.
> >
> > 1. I have employee evaluation forms set up in the database. Is there a way
> > to restrict viewing of a specific entry to only certain people (example:
> > Laurie, her boss and Senior management should be the only ones with access
> > to
> > Laurie's evaluation and Laurie should be the only be able to edit one
> > field
> > in this form) is this possible?
> >
> > 2. Finally, I know its possible to prevent editing once a form has been
> > completed  by allowing imput but no editing but is it possible to recreate
> > a
> > button or field that once clicked or checked will lock the form so it
> > cannot
> > be changed? The evaluation form is several parts and the reviewer and the
> > reviewee both need to enter in their portions but it needs to be locked
> > once
> > completed.
> > --
> > Lori A. Pong
>
>
>