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

    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 - Copy.zip

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Requery the data
    Colin, Access MVP, 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
    Posts
    58
    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
    Location
    Ontario, Canada
    Posts
    12,737
    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
    http://rogersaccessblog.blogspot.com...on-part-i.html
    and/or
    http://holowczak.com/database-normalization/

    Entity-Relationship Diagramming: Part I, II, III and IV
    http://rogersaccessblog.blogspot.com...ng-part-i.html

    How do I Create an Application in Microsoft Access?
    http://rogersaccessblog.blogspot.com...cation-in.html

    Important for success:
    Naming conventions - http://access.mvps.org/access/general/gen0012.htm
    https://www.access-programmers.co.uk...d.php?t=225837

    What not to use in names
    - http://allenbrowne.com/AppIssueBadWord.html

    About Auto Numbers
    - http://access.mvps.org/access/general/gen0025.htm

    The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
    Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
    About calculated table fields - http://allenbrowne.com/casu-14.html
    About Multi Value Fields - http://www.mendipdatasystems.co.uk/m...lds/4594468763
    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
    Posts
    58
    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