Creating a form where fields auto populate and can be manipulated

I am creating a surplus database for our equipment where a region field is the constant and the remaining fields populate based on what region is selected.  I want to be able to select a region and then update the fields within that region so essentially i would only have 11 total records since we have 11 regions.  

I thought i could use theory of autopopulating fields based on a particular field being selected, then just make changes to the necessary fields which would store data on our inventory.  However, whenever i select a region and update some of the fields, it changes the first record with this data.  

For instance, there are 4 records under the region field.  These are 1, 2, 3 & 4.  If i change data on region 3, the region 1 field changes to 3 so now i have two records with Region 3 even though i did not change that field.  If i go and change data for region 4, the first record which was once 1 and now 3, then becomes 4.  For some reason it is only changing the region on the first record.  

Is there anyway in Access i can create this type of database so i can modify fields under a region keeping that field the same.  I know how to remove options in a form so no one can create new records and the only way they would be able to navigate to another record is using the drop drop for the region field.  

I have attached a sample database and if you look at the row source and column counts for the region field and then the code, you will see what i have attempted.  I know typcially this type of functionality pulls from a separate table so not sure if that is what i need to do in order to get this to work.  

Please let me know if you require any additional information.
Who is Participating?
Rey Obrero (Capricorn1)Commented:
you should use an unbound combo box to select your record
jsawickiAuthor Commented:
I knew there was a simple solution.  Thanks a bunch
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.