I think I am being really dense, but I can't seem to get the listbox to populate based on the combo selection.
The combo's rowsourcetype is FIELD LIST and the rowsource is a query:
SELECT DISTINCTROW tblEmployees.[First Name], tblEmployees.[Last Name], tblEmployees.[Pulse ID], tblSystems.[System Name], tblEmployees.Email, tblDepartment.Department, tblBusinessDescp.BusinessDescription, tblManagers.Manager, tblJobBands.[Job Band], tblThirdPartyCo.ThirdPartyCompany
FROM tblSystems RIGHT JOIN ((tblThirdPartyCo RIGHT JOIN (tblJobBands RIGHT JOIN (tblManagers RIGHT JOIN (tblBusinessDescp RIGHT JOIN (tblDepartment RIGHT JOIN tblEmployees ON tblDepartment.DepartmentID = tblEmployees.[Department ID]) ON tblBusinessDescp.BusinessDescriptionID = tblEmployees.[Business Description ID]) ON tblManagers.ManagerID = tblEmployees.[Manager ID]) ON tblJobBands.JobBandID = tblEmployees.[Job Band ID]) ON tblThirdPartyCo.ThirdPartyID = tblEmployees.[Third Party ID]) LEFT JOIN tblEmployeeAccess ON tblEmployees.EmployeeID = tblEmployeeAccess.[Employee ID]) ON tblSystems.SystemID = tblEmployeeAccess.[System ID]
WHERE (((tblEmployees.[First Name])=[Forms]![frmInfo]![cboInformation]) AND ((tblEmployees.[Last Name])=[Forms]![frmInfo]![cboInformation]) AND ((tblEmployees.[Pulse ID])=[Forms]![frmInfo]![cboInformation]) AND ((tblSystems.[System Name])=[Forms]![frmInfo]![cboInformation]) AND ((tblEmployees.Email)=[Forms]![frmInfo]![cboInformation]) AND ((tblDepartment.Department)=[Forms]![frmInfo]![cboInformation]) AND ((tblBusinessDescp.BusinessDescription)=[Forms]![frmInfo]![cboInformation]) AND ((tblManagers.Manager)=[Forms]![frmInfo]![cboInformation]) AND ((tblJobBands.[Job Band])=[Forms]![frmInfo]![cboInformation]) AND ((tblThirdPartyCo.ThirdPartyCompany)=[Forms]![frmInfo]![cboInformation]));
The listbox rowsource is a query:
SELECT qryInfo.[First Name], qryInfo.[Last Name], qryInfo.[Pulse ID], qryInfo.[System Name], qryInfo.Email, qryInfo.Department, qryInfo.BusinessDescription, qryInfo.Manager, qryInfo.[Job Band], qryInfo.ThirdPartyCompany
FROM qryInfo;
I am not sure why the listbox won't list the information based on the combo selection...
Any thoughts?
The combo's rowsourcetype is FIELD LIST and the rowsource is a query:
SELECT DISTINCTROW tblEmployees.[First Name], tblEmployees.[Last Name], tblEmployees.[Pulse ID], tblSystems.[System Name], tblEmployees.Email, tblDepartment.Department, tblBusinessDescp.BusinessDescription, tblManagers.Manager, tblJobBands.[Job Band], tblThirdPartyCo.ThirdPartyCompany
FROM tblSystems RIGHT JOIN ((tblThirdPartyCo RIGHT JOIN (tblJobBands RIGHT JOIN (tblManagers RIGHT JOIN (tblBusinessDescp RIGHT JOIN (tblDepartment RIGHT JOIN tblEmployees ON tblDepartment.DepartmentID = tblEmployees.[Department ID]) ON tblBusinessDescp.BusinessDescriptionID = tblEmployees.[Business Description ID]) ON tblManagers.ManagerID = tblEmployees.[Manager ID]) ON tblJobBands.JobBandID = tblEmployees.[Job Band ID]) ON tblThirdPartyCo.ThirdPartyID = tblEmployees.[Third Party ID]) LEFT JOIN tblEmployeeAccess ON tblEmployees.EmployeeID = tblEmployeeAccess.[Employee ID]) ON tblSystems.SystemID = tblEmployeeAccess.[System ID]
WHERE (((tblEmployees.[First Name])=[Forms]![frmInfo]![cboInformation]) AND ((tblEmployees.[Last Name])=[Forms]![frmInfo]![cboInformation]) AND ((tblEmployees.[Pulse ID])=[Forms]![frmInfo]![cboInformation]) AND ((tblSystems.[System Name])=[Forms]![frmInfo]![cboInformation]) AND ((tblEmployees.Email)=[Forms]![frmInfo]![cboInformation]) AND ((tblDepartment.Department)=[Forms]![frmInfo]![cboInformation]) AND ((tblBusinessDescp.BusinessDescription)=[Forms]![frmInfo]![cboInformation]) AND ((tblManagers.Manager)=[Forms]![frmInfo]![cboInformation]) AND ((tblJobBands.[Job Band])=[Forms]![frmInfo]![cboInformation]) AND ((tblThirdPartyCo.ThirdPartyCompany)=[Forms]![frmInfo]![cboInformation]));
The listbox rowsource is a query:
SELECT qryInfo.[First Name], qryInfo.[Last Name], qryInfo.[Pulse ID], qryInfo.[System Name], qryInfo.Email, qryInfo.Department, qryInfo.BusinessDescription, qryInfo.Manager, qryInfo.[Job Band], qryInfo.ThirdPartyCompany
FROM qryInfo;
I am not sure why the listbox won't list the information based on the combo selection...
Any thoughts?