2 Subreports on main form

[mari_hitz]

Hi everyone,

Hope you are great. I wanted to know if what I am trying to do is possible. I have a table with tasks for different countries, then I have a query that filters the table depending on the Country inserted on the criteria parameter pop up. Then I created a report based on the query.


If I would like to compare two countries with the same report, I tough to make a form containing two sub reports and in the form above each report put a combobox with the list of countries. Then if somebody would like to compare two countries they will have to choose from each drop downs the countries to compare and the sub reports would be updated with the data of the countries chosen.
Is this possible? How can I do it? I tried to search on the Internet this but I did not find any answer, I know there is something with requery, but I don't understand how to do it.
Could you please guide me?

Thanks!

[rpeare]

I am not sure I understand the question but let me see if I do.

You have a report that prints out what you want just fine.

What you want to do is have this report compare two countries side by side for a comparison. The problem is that you don't know how to select 2 countries for a query

The easiest way I can figure to do this is to have two combo boxes on your form (instead of, I assume, 1 right now)

In the criteria if the query driving the report you could have a criteria in your COUNTRYID field of:

[Forms]![FORMNAME]![Combo1] or [Forms]![FORMNAME]![Combo2]

Your query should return two records instead of 1 (one record for each country) Then you can build a report around the two record query.

[June7]

Report view does allow some interaction but reports are not intended to be interactive, this is what forms are for. Could just use subforms.
Regardless, RecordSource would be dynamic parameterized query with parameter referencing combobox on form. Then click the refresh on ribbon or build button with requery code.

[NTC]

As the others have noted, your post is a little difficult to interpret; but in general yes one can certainly compare 2 different countries that are dynamically selected by the user. It is not however a generic feature so it is all about learning to design. If you want your results to be a comparative report - then you must set it up generically with Country 1 and Country 2.... then you need to work backwards and establish a form whereby the user can select/enter the countries - which in turn serve as criteria for the query which is in turn the record source of your report......

Beyond novice status, sure, and difficult to find a precise guide on the internet because it is very custom.....but very do-able.....