Results 1 to 6 of 6
  1. #1
    JonathanT is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2011
    Posts
    145

    Combobox Not Updating Table


    I have a combo box on Form A that stores it’s values in Table A. When I update the combo box the value in Table A doesn’t change until I either close Form A or click a refresh button I created. Is there a way to make the combo box automatically update Table A when a change is made?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Save the record in the AfterUpdate event?
    No chance to Undo then though?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Join Date
    Apr 2017
    Posts
    1,792
    Is the combobox bound (The table field is it's Control Source property, and any changes are saved when another record is activated unless Undo is invoked) or unbound one?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Record edit is committed to table when form closes or move to another row or run code to save. That's the way bound form and controls work.
    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
    JonathanT is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2011
    Posts
    145
    Thanks Welshgasman. That is exactly what I needed. I added "me.refresh" to the AfterUpdate property

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Might find this of interest http://allenbrowne.com/bug-01.html
    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.

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

Similar Threads

  1. ComboBox not updating values
    By aexsar in forum Programming
    Replies: 3
    Last Post: 12-19-2017, 01:20 PM
  2. Calculated field in Combobox Not Updating
    By LemonRawr in forum Access
    Replies: 1
    Last Post: 02-10-2017, 02:17 PM
  3. ComboBox not Updating Field
    By The Professor in forum Forms
    Replies: 2
    Last Post: 08-01-2014, 09:19 AM
  4. Replies: 7
    Last Post: 03-02-2014, 08:47 PM
  5. Combobox not updating
    By lostfan789 in forum Forms
    Replies: 15
    Last Post: 06-16-2010, 09:21 PM

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