User Level Permission/Access to certain forms

[kmims44]

I know this topic has been discussed many times but the way my database is set up I can't figure out how to get my permissions functioning. I have a login that store the employee's name as TempVars![CurrentUserID]. On the Employees Table there are fields called "PR Access" "WO Access"...etc. Is there a way to run a query like Find CurrentUserID, if field is True, allow user to open Form X, Form Y, Form z...etc.?

[June7]

I have never used TempVars, however, I doubt what you want can be done.

I store user ID on a form that never closes, such as MainMenu. That way it is always available for reference by code and queries.