Sending Criteria to a Report

[irsmalik]

Hi friends

I changes the Territory Combo Box to List Box.
Multi Select = Extended

Now how to pass this criteria to Report.
Report Query is based by selection of
1 Company
1 Region
1 Territory.
Now how to set is for Multi Select Territory.

All are request for help.
Regards
Irshad Ahmed

[twinnyfo]

Irshad,

I moved your post to a new thread, as it truly is a new topic.

[twinnyfo]

What you are trying to do is actually built into the call to open a report in Access:

Call DoCmd.OpenReport(ReportName:="YourReportName", _
                      WhereCondition:="Company = " & Me.cboCompany & _
                             " AND Region = " & Me.cboRegion & _
                             " AND Territory = " & Me.cboTerritory)

Hope this hepps!

[NeoPa]

Twinny mentions the possibility of passing the criteria in a call to DoCmd.OpenReport. WhereCondition is one of the possible parameters, and probably the most pertinent for your question. However, it doesn't hurt to know that there is also another called OpenArgs. Literally for passing an argument, or multiple ones within a single string if required, to the Report.

[twinnyfo]

Hey, NeoPa! Thanks for fixing my named argument! Sometimes I just get typing a forget to check these things.

Thanks for keeping me in line!

:-)

[NeoPa]

Hey. It's easier than doing all the work you guys do still ;-)

[irsmalik]

Hello dears .......... this is my sql for Single Selection of Company, Region, Territory, and Territory List Box is set to Multi Select = None

SELECT Territory.TerritoryName, Territory.RegionID
FROM Territory
WHERE (((Territory.RegionID)=[Forms]![frmFORM002]![Region_Combo2]))
ORDER BY Territory.TerritoryName;

This is working well and my required Territory Data is at Report preview.

I change In Territory List Box Property
Multi Select = Extend

Now even Single Territory is NOT working and Message
"There is No Data for selected Territory".

Where I am making Mistake.. What is the other way.. Seniors are requested for help.

Thanks
Irshad Ahmed

[twinnyfo]

You have to extract the individual values from a List Box in order to use them.

This Thread (Retrieve Values from a Multi-Select Listbox) may be helpful.

Once you create that string, you can use that value to filter your report:

"Territory IN (" & strValue & ")"

You would use this in conjunction with Post #3 above and the value generated in the linked thread.

Let us know if you require additional assistance on this one.