MS Access: Dispaly multiple specific records on one form (not using multiple items)

Vote count:

0

tldr: I want to create a form where specific fields from specific records are displayed based on filters or parameters. I do not want to use a subform or multiple item form.

the context: I am creating a database with information about different countries. My table Indicators (picture 1) contains country names, indicators names (e.g. Population, GDP, ...) and the repspective values. I will collect data on the same indicators for every country. I want to create a form where I can select a country, and then display the values of the indicators are for that country (picture 2). I do not want to use a multi item form, because I want to create a visually appealing layout.

I have made a sketch of my data table http://ift.tt/NFqDZk And the form I want to create http://ift.tt/1ox8YOG

I would be greatful for any suggestions how to build such a form.

asked 1 min ago

malte

1