Just wondering if there is a way to set permissions or some VBA that will render records viewable and editable only to the user that has created it on the split form?
Currently I have it set as a single form. But surely there's a way of doing the above mentioned? My goal is that I don't want users to be prying eyes on others records. But I still want them to be able to view their records and make changes if required.
In saying that, if that is possible, is there also a way to make those records viewable but not editable? In case I don't want them making changes but they can still view their work in case they need to. Just deciding which would be better for my database. Thanks.
P.S. I am receiving Computer Name and their Username via Environ code. I know this can be spoofed, so will work on WShell.Network module. But just wondering if that information could help with the above?
Currently I have it set as a single form. But surely there's a way of doing the above mentioned? My goal is that I don't want users to be prying eyes on others records. But I still want them to be able to view their records and make changes if required.
In saying that, if that is possible, is there also a way to make those records viewable but not editable? In case I don't want them making changes but they can still view their work in case they need to. Just deciding which would be better for my database. Thanks.
P.S. I am receiving Computer Name and their Username via Environ code. I know this can be spoofed, so will work on WShell.Network module. But just wondering if that information could help with the above?
Last edited: