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.