Creating a form where fields auto populate and can be manipulated

Posted on 2012-09-13
Last Modified: 2012-09-13
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.
Question by:jsawicki
    LVL 119

    Accepted Solution

    you should use an unbound combo box to select your record

    Author Closing Comment

    I knew there was a simple solution.  Thanks a bunch

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This script will sweep a range of IP addresses (class c only, and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now