Limit user's access in forms and reports

[mikejaytlabustro]

Hello!

I just want to know what is the best way and good practice in limiting
user's access in form or report.

For example, i have 2 users in my UserTable, one is Administrator and the other is just ordinary user.

In case i want the ordinary user to open the form in "Read Only" mode, and the Administrator in "Edit" mode.

Do I need to make a code for each form to be opened or there's another easy way to handle this? (I am thinking for additional fields in UserTable to store their individual rights, but after that i don't know what to do next)

Thank you in advance!

 

[CJ_London]

This is a common request - if you open this thread and look at the bottom, you will find a number of links on this subject