Good Day,
I have an access form named frmManagers and within the form I have two Listboxes namely lstManagers and lstStaff. On my lstManagers listbox, my Row Source are EmpID, LName, FName, Manager (tblEmployee) and on my lstStaff listbox the Row source are EmpID, LName, FName and Manager (tblEmplyee). I have 3 unbound textboxes and 4 command buttons (New, Save , Update and Delete).
If I select a manager in my lstManagers, the infomations are displayed on the 3 unbound texbox wherein I could perform Update or Delete for that record.
My problems are:
Problem 1. to display the employee or employees who are directly reporting to this manager (based on the LName of the Manager in lstManagers) and display the results in my lstStaff listbox.
Problem 2. based from the result in Problem 1, be able to change the Manager's LName in lstStaff in one sweep instead of changing every employee record.
Please help.
I have an access form named frmManagers and within the form I have two Listboxes namely lstManagers and lstStaff. On my lstManagers listbox, my Row Source are EmpID, LName, FName, Manager (tblEmployee) and on my lstStaff listbox the Row source are EmpID, LName, FName and Manager (tblEmplyee). I have 3 unbound textboxes and 4 command buttons (New, Save , Update and Delete).
If I select a manager in my lstManagers, the infomations are displayed on the 3 unbound texbox wherein I could perform Update or Delete for that record.
My problems are:
Problem 1. to display the employee or employees who are directly reporting to this manager (based on the LName of the Manager in lstManagers) and display the results in my lstStaff listbox.
Problem 2. based from the result in Problem 1, be able to change the Manager's LName in lstStaff in one sweep instead of changing every employee record.
Please help.
