So how do I filter a form to only show Brad? The table has a ProfileName field that can filter by.
So how do I filter a form to only show Brad? The table has a ProfileName field that can filter by.
I've attached an example database with the login form; once you login, the form showing only the user's info is shown. All of the code necessary is behind the button on the login form.
username: harry.potter
password: wizard
To bypass the login, hold down the shift key while opening the database.
So that worked for filtering the persons profiles but then each person only has 1 profile. But now I need to know how to filter the records in the Daily Tracking table. There will be multiple users with multiple records. How do I filter these tables so that the person logged in can only see their records?
If a person has multiple things related to them, you would show those related things in a subform on the main form. When you filter the main form for the person only their information will be shown (in both the main and the subform).
You will have to provide more detail on your tables including fieldnames and how the tables are related to each other.But now I need to know how to filter the records in the Daily Tracking table. There will be multiple users with multiple records. How do I filter these tables so that the person logged in can only see their records?