Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145

    Update Cascaded Combo Box on Forms after Update on Tables


    Hi Forum,

    I have a cascaded combo box that narrows info from the previous combo box and I had made some changes within the information from those tables that are rowsourced to the combo box. The problem is that, after the update changes in the table, it does not update on parent table (which contains the info from the updated table) or the forms associated with it. I would have to go into forms and reclick the drop down box to update the information. Is there a way I can update the existing data I have with the updates that I changed. Hope this isn't confusing.

    Thanks,
    Raymond

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    click the REFRESH ALL button on the top toolbar

  3. #3
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    It doesn't work. It's a combo box drop down. I have to click on the drop down and reselect it.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    What is your code that updates the table? Need code in some event that will requery the combobox. The code is simple, the real trick is figuring out what event to put code into. Me.comboboxname.Requery

    I am confused by "after the update changes in the table, it does not update on parent table (which contains the info from the updated table)".
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    The table where the cbo box is rowsourced (provides the list of options) from and the main table where the contains all the data.

    June, do I have to use this on the "Design" form. I basically changed the some of existing names of the table where the cbo box is rowsourced from. It doesn't change because I think it's affected cascaded box; therefore, I have to go into the cbo box and reselect the "changed" naming myself.

  6. #6
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    All my table shows the "old" names until I reselect the cbo box to select the "new" ones.

  7. #7
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    In the form's AfterUpdate event, requery the combobox(s)
    Me.combobox.Requery
    this will go back to the table and refresh the row source.

  8. #8
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    Quote Originally Posted by aytee111 View Post
    In the form's AfterUpdate event, requery the combobox(s)
    Me.combobox.Requery
    this will go back to the table and refresh the row source.
    Sorry guys! It doesn't work.. The existing data is still there until I reselect it to change is manually.

  9. #9
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    There is something going on then that we are unaware of. You can't change a combobox manually, so what is it? If you could tell us the exact steps you are performing, I am sure we can find the issue. Did you requery both comboboxes in the AfterUpdate?

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Along with describing the steps, can provide db if you want. Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  11. #11
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    Keep in mind that I had existing data that were without the changes. Once I made the changes on the table, I have to select the combo box again to select the "made" changes. These changes are really minor. They are grammatical changes.

  12. #12
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    Click image for larger version. 

Name:	Picture.jpg 
Views:	14 
Size:	85.3 KB 
ID:	31582

    Here's the picture!

  13. #13
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    So I've just been going into the drop down list to reselect the change ones. But there's a lot of data to be changed. The "Location Inspection" is cascaded from the previous combo box "Work Area".

  14. #14
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Exactly what data is saved into the Location Inspection field? Is it the record ID of the lookup table or is it the actual descriptive text? If you are saving the text then changing the value in the lookup table will not carry over to the Location Inspection field.

    Sounds like to me you are saving the text, not the record ID.

    Looks like changing a number, not grammar.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  15. #15
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    Quote Originally Posted by June7 View Post
    Exactly what data is saved into the Location Inspection field? Is it the record ID of the lookup table or is it the actual descriptive text? If you are saving the text then changing the value in the lookup table will not carry over to the Location Inspection field.

    Sounds like to me you are saving the text, not the record ID.

    Looks like changing a number, not grammar.
    Yes June7,

    It is the numbers that has changed. The data that is saved is the one "12.65" <-- Existing. The new "12.67" was updated after I changed it from the table that the combo box is rowsourced from.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-15-2014, 01:44 PM
  2. Replies: 3
    Last Post: 10-25-2012, 11:21 AM
  3. Update Tables from Combo Boxes in a Form
    By RedWolf3x in forum Access
    Replies: 3
    Last Post: 11-03-2011, 08:07 AM
  4. Replies: 10
    Last Post: 07-12-2011, 11:09 PM
  5. update tables via forms
    By jazoo in forum Forms
    Replies: 0
    Last Post: 09-16-2008, 05:54 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