passwords to restrict access to records

[Guest]

I am fairly new to access (4 weeks) and am building a customer database. I
have one main form with several tabs and subforms on it. Currently when the
database is opened they enter their name, press a button which takes them to
a switchboard from which they search for customers based on criteria (i.e.
Name, phone number, contact, etc.)

The main table, tblCustomers, has a field, Employee, that assigns each
customer to an employee. When the database is opened and they enter their
name I want each employee to access only those records associated with their
name. As well I need some fields on the main form, frmCustomers, to be
automatically populated once the employee signs in, though that is currently
working with just entering their name.

I understand, I think, the securing of the database. I've successfully
assigned user permissions and such. I just don't know if the logins for the
database can be used to pull up records associated with only that employee.

Maybe this is easy. As I said I'm new, so maybe I have things all messed up.
Any help is greatly appreciated.

Thank you.

 

[pietlinden]

If you are writing the usernames to the records they belong to, you
should be able to filter the records the user can see by setting the
rowsource for all your forms to

SELECT...
FROM ...
WHERE MyTable.Username=CurrentUser