filter report by value in subform (1 Viewer)

lbs · Jan 9, 2020

Hello experts

I have a form which has a subform. At the bottom of the main form I have a button for opening a report. I want that report to be filtered according to the value showing in one filed of the subform. Is it possible to achieve? How to write a where condition in the Open report command?

Many thanks

Ranman256 · Jan 9, 2020

the query for the report would use the selected record as the criteria.
open the form (w the subform)
make a query, then use the BUILDER to insert the criteria.
select active forms
your form, then the subform,
then the field (txtbox).

theDBguy · Jan 9, 2020

Hi. Also, if you use the OpenReport method, there is a WhereCondition argument. For example:

Code:

DoCmd.OpenReport "ReportName", acViewPreview, , "ReportFieldName='" & Me.SubformContainerName.Form!FieldControlName & "'"

That's assuming it's a Text field.

lbs · Jan 9, 2020

theDBguy, Ranman256,
Many thanks

It works now

theDBguy · Jan 9, 2020

lbs said:
theDBguy, Ranman256,
Many thanks

It works now

Hi. Glad to hear you got it to work. Good luck with your project.

filter report by value in subform (1 Viewer)

lbs

Registered User.

Ranman256

Well-known member

theDBguy

I’m here to help

lbs

Registered User.

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread