I created a subreport "ResidentCareReviewsmainfrm" but can't filter the data by inactive and active since the record source isn't the query but the table. The filter I want to filter the data by those records that are not "inactive" and payer is "Medicare". Also, I want to search for all active records but it errors out when I go to the record number to search for a specific resident (patient).
Also, I want to change the layout to columnar but it won't allow me to change it even though I selected remove layout.
I would appreciate any assistance with the subreport.