Results 1 to 5 of 5
  1. #1
    MPXJohn is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015

    Access 2010 Update made to data in a query does not update in forms

    I have a small database where I enter the data through a form. The form draws some data via combo box which gets its data from a query. If I change the data in the query it does not update in the form. I have to go back into the form in that combo box and re-choose the changed data. Is there a way to have that change automatically. Thanks for any help.

    Sample Database -

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Somerset, UK
    Requery the data
    Colin, MVP 2022, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    MPXJohn is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Tried that already and it does not work. Even if I close everything out and re-open the form, I still have to click the drop down for the combo box and re-choose the changed data. Thanks

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    If you don't fix the foundational errors (tables design) you will continue to have issues like this. For starters, your form is based on a query join between a non-indexed table field on one side and a calculated (concatenated) field on the other side. You should review db normalization and make sure you understand the PK - FK (primary key - foreign key) parts. In addition, avoid special characters (save for underscore) and spaces in object names, avoid using reserved words (e.g. description). Unfortunately I have to go out in about 20 minutes so I don't have time to see if your current issue can be fixed. In the meantime, here's some links that will help immensely should you choose to study them.

    Normalization Parts I, II, III, IV, and V

    Entity-Relationship Diagramming: Part I, II, III and IV

    How do I Create an Application in Microsoft Access?

    Important for success:
    Naming conventions -

    What not to use in names

    About Auto Numbers

    The evils of lookup fields -
    Table and PK design tips -
    About calculated table fields -
    About Multi Value Fields -
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    MPXJohn is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Thanks Micron. I am going to go ahead and mark this solved as I read over all the info you supplied.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. update query results when report is made.
    By Homegrownandy in forum Queries
    Replies: 10
    Last Post: 10-28-2015, 07:44 AM
  2. Replies: 15
    Last Post: 11-18-2013, 01:49 PM
  3. Replies: 3
    Last Post: 10-31-2013, 02:36 PM
  4. Update access Forms and data type
    By Amen in forum Access
    Replies: 4
    Last Post: 09-25-2013, 05:49 PM
  5. Replies: 1
    Last Post: 06-27-2012, 09:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums