"Joan Wild" wrote:

> There is code in the security FAQ you can use to determine if a user is a member of the Admins Group.  In the open event for the form, you can lock/unlock that control based on group membership.
>
> Security FAQ: http://support.microsoft.com/?id=207793
>
> --
> Joan Wild
> Microsoft Access MVP
> "Tim" <T**@discussions.microsoft.com> wrote in message news:B386D857-F4ED-467D-B862-73F4A4CA3D8E@microsoft.com...
> > Thanks for the lock suggestion but unfortunately that would create another
> > problem - I (as an administrator) need to be able to enter a value in that
> > field.
> > If I lock the field I won't be able to change the contents either.
> > The database is packaged as an application so unlocking when I need
> > to enter data is not practical either. That's why I suggested a password.
> > Any other ideas?
> >
> >
> > Thanks!!!!
>