Limit User record views

Hello

I am not sure if this is even possible but I figured I would throw it out here and see if it can be done. I have a Access Form linked to one table, there will be people from multiple departments entering data into this form. Right now the Form shows all of the records in the database when scrolling through them with the navigation command buttons.

I am trying to figure out if there is a way to only show records that are a part of the users department. So if I am work in Accounting the form will only show records from accounting, and not records from legal. I am thinking that this would be based off the User Name (which my form already gets), but there might be a better way.

Thanks in Advance

Thanks Alan

I am still reading through your link trying make sense of it. I found something similar to that here
http://www.databasedev.co.uk/filter_current_user.html

I got this working so that the form only displays records that match by username. I am trying to figure out how to extend this to a department. I am getting the user names from Windows not from access table.

The setup where a a user can only see records they have entered on in the Form works. Now I just need a way to link a user name to a department and only allow them to run reports based of their department.

If this does not make sense let me know and I will try to re word it.

Thanks in Advance

That is what I was thinking I would have to do. Since I am new to Access do you know of any websites explaining how to do this off the top of your head.

Thanks in Advance.

That is what I was thinking I would have to do. Since I am new to Access do you know of any websites explaining how to do this off the top of your head.

Thanks in Advance.

Thanks

I have set up the table, combo box, and text box following directions you gave. My table is called "tblUserDept" my form is "frmFileSearch" the combo box is "cmbUserId" and the text box is "txtDept". The only thing left is making the combo box and text box be hidden and auto fill. This way it will prevent anybody in legal from running a search on accounting records, since they are not authorized to view them. I tried the following code with the combo box and text box set up just like the ones on the baldyweb site.

Please Login or Register  to view this content.

This does fill cmbUserId box but txtDept just shows "#Name?", even though my username matches the name in cmbUserId.

Thanks in Advance

Another issue that I am having is with the Query that this search form runs. In the field that I want "txtDept" to be tied to put this in the Criteria box.

Please Login or Register  to view this content.

The problem is that query still returns all of my records from all depatments. For all of the other fields I have the following in the "or" box stepping down one line after the other.

Please Login or Register  to view this content.

The same thing. I also get an error message that highlights the the following code in yellow

Please Login or Register  to view this content.

This happens "on load" as well as "after update"

I will do that, it may take me a little bit of time so I will probably upload it tomorrow 8/21/13.

Thank You for helping me out

Here is my Access file
RIM2013.zip

The file RIM2013_Dev is where all of my forms are at with the linked tables in RIM2013_be, you need to hold down shift to access all of the menus when opening. If you have any questions let me know (I am new to all of this so the way I have done some things tht may seem weird). The form "frmFileSearch" is where I have set up the text boxes for the userID and their department. Also I just noticed that none of my search forms are working correctly.

If you can figure this out, you will be a lifesaver.
Thanks in Advance

Hello Alan,

I am just wondering if you have had a chance to look over my Access program. I am sure it takes a while to understand someone else's work and that it could be a while before you might be able to solve my problem.

Thanks

Thanks, let me know if you have any questions