Trying open a report and filter the data so that I see Data from the Status_txt Field that is AWM, INW or AFD but I only want it to show the data where the CAL_AREA_1 comes from the form control of Forms!Main!KareaList
I thought the below should work but it returns Status_txt that is AWM, INW or AFD but includes ALL Cal_Areas_1 data not just the CAL_AREA_1 That I selected on the forms
DoCmd.OpenReport "Daily Workload List AWM-INW-AFD", acViewReport, , "STATUS_TXT = 'AWM' OR STATUS_TXT = 'INW' OR STATUS_TXT = 'AFD' AND CAL_AREA_1 = Forms!Main!KareaList"
A Scrubbed version is hereDatabase2.zip