I am using an access form that users would use to request access to certain databases. When they open the form, their username is displayed on the bottom. I am trying to have the second column of a listbox show the user whether they already have access to the database that would be in the first column. What I figured I would do is link the tbl_users from a database that I would use to compare their username to the linked table, have a query run to check their username against the tbl_users and if it is there, the second column would say “Access” or “No access” or something like that to let them know.

I tried to make a query with the usernames from the tbl_users and the first column only displayed their usernames and not the database names that would be static and never change. I’m not sure if I need to link all the databases tbl_users and make a query to compare the usernames to or just link the tables and compare to them instead. I can’t get the first column to be the database names and then the second column to display something to let them know if they have access or not.