Access specific form by user

[GilbertPet]

On a screen I want to give permission to specific user. i.e user 1 can access screen 1 and cannot access report screen. or user 2 access screen to modify and view report in access 2010

[pdebaets]

This function might help: http://access.mvps.org/access/api/api0008.htm.

With it you can put the following code in your form OnOpen event procedure

if fOSUserName = "SomeName" then
msgbox "You are not allowed to view this form."
docmd.close acform, me.name
end if