I am new to ACCESS. I have made a switchboard from my DataBase. One report works fine. rptOfficerJobs. The other report for departments produces a report without data. Manually the qryDepartmentJobs and rptDepartmentJobs work frmGetDepartment seems to be the trouble. The frmGetOfficers works fine. I cannot see my error. Help.
Attached DataBase and manual from Documenter.