Hello,

Scenario:
I have list of policies for different countries. What I have done so far is that I have designed a query for each country which will pull out the policies for that country. The report is bases on this query. However, this way I am creating lot of queries.

What I want to do is design a query (and therefore the report) so that I can pull out the policies for a country by simply selecting a name from a drop down.

Tables and Fields are as below:

Table[Country]
CountryID
CountryName

Table[Policy]
PolicyID
CountryID
PolicyDetails

I know I can use the paremeter in the Criteria field but if the list is big, this is not very conducive. I would like a drop down which will show all the available choices. After selecting one of the choices, I want the report to be created based on my selection.

Could you please advise if this is possible and if yes, how to achieve this?

PS -I am not very familiar with VBA. If you could explain how it could be done using Query design, that will be great.

Many thanks.

Hi Joe,

Please see the relationship diagram, I was using the following tables - Jurisdiction, Junction_Jur_Rules, RulesMap, RuleDetail, L1Owners, Junction_RuleDetail_L1Owner.

I have the query and the form in the attached DB.

Really appreciate your help. if you need any info let me know.

Thanks,
SG