Yes please for the code. As for everything else, thank you very much.

how to make an access login with rights to user information

Ok, so I need to take that code and put it into my VBA module, and then attach it to my login form? Does this make it to where one part of the company can only see their information? The reason I ask this, is because I am trying to make this for a company that has many parts.
For Example:
There are 8 companies. Company A, B, C, D, so on so forth.
There...

I want to create a login form for multiple users with different rights, and they can only see information in my queries and reports that pertain to them. For example: User1 logins in, on the switchboard I only want user1 to be able to see certain things. Then when user1 goes to see a report, it only shows user1, user1's information.

Now by what I have read and can gather, I will need a user table, and that table will have to have their...