In an Access database I've acquired
tblStaff has a field called StaffID, a field called StaffInitials and 3 Yes/No fields called Admin, Finance and TechSupport.
tblDepartment has a field called DepartmentID, DepartmentName and 3 fields called AdminID, FinanceID and TechSupportID
I have created a form called frmStaffDepartment with an unbound combo box called cboStaffID with the row source SELECT [tblStaff].[StaffID], [tblStaff].[StaffInitials]
FROM [tblStaff] ORDER BY [StaffInitials];
frmStaffDepartment has a subform called subDepartment which has a query based on the fields in tblDepartment (which orders by DepartmentName)
When I select a member of staff in the cboStaffID combobox, I'd like the subform to list all department where the staff member is either the AdminID, FinanceID or TechSupportID
Start Free Trial
