Populating listbox on a form using multiple fields.

[bakkouz]

Hey guys,

Beginner here.

I have a table called Prod_DB, in this table i have a field called "Country" which stores country names, and then i have many other fields for years, ie: a field called "2009" which stores values (production in Kilograms) relating to the country in field "Country" and another field "2010" and field "2011" and so on.

So basically its a table which stores production numbers of fertilizer for certain countries by year.

I have a form "form1" which has a combo box used to select county names and then populate a list box based on the selection made.

now what i want to do and cannot figure out how to do it is how to create a similar combo for the years, since the values are stored in many fields.

to simplify the issue, i want the user to select a country (or countries) and select the desired year (or years), from the table Prod_DB, and then display a report containing the desired information.

I have attached the sample database.

thank you in advance.Production.zip

[ssanfu]

This will be a little (to very) difficult because your table structure is not normalized. You are "Committing Spreadsheet" .

This should help: http://www.google.com/#hl=en&tbo=d&s...w=1280&bih=882

I'll look at your dB tonight when I have use of A2K7..

[Missinglinq]

ssanfu is absolutely right! Your Table is not really a Table at all, but is, in fact, simply a spreadsheet! At the least, the Fields in this Table should be

• Country_ID
• Country
• ProductionYear
• FertilizerProductionAmount

Some would even split this up into two Tables, with Country Table having

• Country_ID
• Country

and a Production Table having

• Country_ID
• ProductionYear
• FertilizerProductionAmount

Then you'd present the data using a Main Form (Country Table) and a Subform (Production Table) scenario, with the Form/Subform being linked on the Country_ID Field for data entry/viewing.

Linq ;0)>