Permissions on Form per Page

2 May 2006 4:07 PM

mfrey

I have several Forms built with several pages each like tabs at the top of
the form. I need to be able to set permissions based on the page so that one
user may have read/write permission to the first Page/Tab, and Read Only
permission for the other 3 on the form. Another user may have Read/Write for
the first two Pages/Tabs and Read Only for the last 2, etc.
If I can't do it per Page/Tab, maybe I can do it per field, and just set
each field on that Page with the same permissions for a particular user?
Suggestions???
Thanks!!!!!

4 May 2006 5:16 PM

mfrey

after reading some of the other posts in this section I'm wondering if maybe
I should post this question in another section??? Please help. Thanks!

Show quoteHide quote

"mfrey" wrote:

> I have several Forms built with several pages each like tabs at the top of
> the form. I need to be able to set permissions based on the page so that one
> user may have read/write permission to the first Page/Tab, and Read Only
> permission for the other 3 on the form. Another user may have Read/Write for
> the first two Pages/Tabs and Read Only for the last 2, etc.
> If I can't do it per Page/Tab, maybe I can do it per field, and just set
> each field on that Page with the same permissions for a particular user?
> Suggestions???
> Thanks!!!!!

4 May 2006 7:46 PM

Joan Wild

You mention pages; I assume you mean you have a tab control on a main form.
Instead of placing various controls on each page of the tab control,
consider creating a subform on each page. You can then set the permissions
on the subform (and its record source) to control whether the user(s) can
read/update/insert/delete on each subform.

The tab, then doesn't really come into it. The permissions are on the
subforms.

--
Joan Wild
Microsoft Access MVP

mfrey wrote:

Show quoteHide quote

> after reading some of the other posts in this section I'm wondering
> if maybe I should post this question in another section??? Please
> help. Thanks!
>
> "mfrey" wrote:
>
>> I have several Forms built with several pages each like tabs at the
>> top of the form. I need to be able to set permissions based on the
>> page so that one user may have read/write permission to the first
>> Page/Tab, and Read Only permission for the other 3 on the form.
>> Another user may have Read/Write for the first two Pages/Tabs and
>> Read Only for the last 2, etc.
>> If I can't do it per Page/Tab, maybe I can do it per field, and just
>> set each field on that Page with the same permissions for a
>> particular user? Suggestions???
>> Thanks!!!!!