I want to filter data in my main report but can't. I want to change layout of subreport.

[Duncan Pucher]

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.

[June7]

There is no report by that name - it is a form.

Exactly which object is issue?

Code can set Filter and FilterOn properties of a form even if RecordSource is a table.

[Duncan Pucher]

Yes , it is a form not a report. I need to filter two fields- “activeinactive” to only if not checked and payer to “Medicare”. I couldn’t get it to filter.

[June7]

Which form - ResidentCareReviewsmainfrm?

Its RecordSource is a query, not a table so why would you say you can't apply filter?

What does "couldn't get it to filter" mean - error message, wrong result, nothing happens - what did you try?

Do you want user to have option to apply/remove this filter? If Not, and you want this filter to be static, include this criteria in RecordSource query.

[davegri]

To have the form show only active residents, change the form recordsource to
SELECT * FROM Residenttbl WHERE ActiveInactive = true;