At the login form, I used DoCmd.ApplyFilter , "Department = 'Finance'"
To restrict user view on the main form so that if the ID and password
Match with the Finance department, the form will only preview the data
From of Finace department's staff. I also put the combo box,FindNextRecord
And FindPreviousRecord to make it become more user friendly. However, the
Combo box doesn't filter the name and show the list of every staff from
Different department. Is there is any way to filter the combo box so that
It will only show the staff name from the Finance department
Note: Every details of each staff are recorded in a single table.