[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

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.
1 Solution
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now