Filter by User

[DREAMERMX]

Hi, I have a database that opens into a continuous form ... which has records and a user name in each, which is taken from a table "ASSIGNED". At the foot of the continuous form I put a filter button to show only the selected user records.


What I need is: That when opening the form, Access asks why I want to filter user (do this only once) ... So each user sees only their records ...


It is clear that the "Front End" is used in a network and is linked to another database with multiple related tables ..


I hope I can help.


thanks

 

[Pat Hartman]

Open the application to a login form. Once the user has logged in, open the continuous form and hide the login form but don't close it. Then modify the query of the continuous form to get the user information from the hidden login form.

Where UserID = Forms!frmLogin!txtUserID .....