Permissions on Form per Page

G

Guest

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!!!!!
 
G

Guest

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!
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top