Form to update a table without read access

[macroRoniAndCheese]

Everyone on my team completes a status report every week and emails it to our fearless leader. I want to create a database where users can fill out this form which then saves their entrys to a table. The tricky part is I would like to restrict the ability to view said table to exclusively Managers as some of this information may be personal. Is this possible?

[June7]

Yes, it is possible. Need a Users table, need to know who is logged in, need code to manage availability of buttons/forms/records. This is common topic in forum. Search forum or google.

Here is one for a start https://www.accessforums.net/access/...gin-23585.html

[macroRoniAndCheese]

Thank you for the quick reply and the helpful info. It's very much apreciated.