"ftrujill0" <ftruji***@discussions.microsoft.com> wrote in message
news:E6979271-3D8C-403E-B2AF-EB294701C2B2@microsoft.com...
> Background:
>
> I have a database that contains records from multiple departments and
> currently have a check that prevents departmental users from changing/edit
> records that do not match their departmental code.  Basically, it is
> stored
> in an form where it checks if current users Dept code  = records Dept code
> if
> true than it is 'ok' to change the record.but if current users Dept code
> does
> not  = record Dept code 'No' change allowed.  This has worked fine in the
> past, but now certain departments are going to have the ability to modify
> other department records and my little check is going prevent this from
> happening.  I was wondering if there is any type of security measures I
> can
> use/add to place record level security to solve my new issue of allowing
> some
> departments the ability to change other department records.
>
> If your confused, imagine how I feel.
>
> More background info:
>
> The user must login using his/her USERID/PWD and there are limited
> security
> groups in place on tables and forms.
>
> Thanks in advance.
>