Permissions on Form per Page

  • Thread starter Thread starter Guest
  • Start date Start date
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!!!!!
 
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!
 
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.
 
Back
Top