Forum Discussion
Populating Comb Box With Multiple Values
I have an Access table with a Regions field and a States Field. The States Field is populated with one to twenty state abbreviations depending on the region. Using VBA, I'd like to populate the Regio...
Your design is not right. Never store multiple values in one field. You need three tables here: Region, State and StateInRegion. Like:
Part of your data will look like:
Ok, thank you very much!
there are only 58 states so no need to super normalized your table, 1 table is enough.
open state table then open form1.
