Results 1 to 9 of 9
  1. #1
    dgarber is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    13

    Text Box In Form Not Updating Table Field

    Hello,



    I have a form with a combo box which has 2 fields of information. I have a text box on the same form which is populated from the combo box and that is working as expected, however the value in the text box is not saving to the field in the table which was used to create the form? Any ideas would be appreciated.

    Very much a NEWB to this.

    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    You could have the textbox bound to its field in the table. Then in the afterupdate of the combo box after you move the value to the text box, do a Save command to save that record.
    Or you could do a "db.execute Update" method, you can look up the syntax of that.

  4. #4
    dgarber is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    13

    Not working correctly Paul

    Quote Originally Posted by pbaldy View Post
    If I am reading your link correctly and I change the Control Source then the auto population of that field no longer functions like it needs to or am I misunderstanding?

  5. #5
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi, if the extra information depends on the value of the combo box, you should put this in a separate table that's used to populate the combobox. The extra information should not be saved to the table you're form is based on.

    kr
    Noëlla

  6. #6
    dgarber is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    13
    and how would I accomplish that?

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I'll get out of the way.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #8
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi, maybe you should take a look at one of the many sites that explain database normalisation. Here is one link, but there are many more: https://www.essentialsql.com/get-rea...imple-english/

  9. #9
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Why do you need to save the other data related to the value saved by the combobox? Is the combobox list pulled from a 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.

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

Similar Threads

  1. Replies: 8
    Last Post: 02-07-2017, 09:58 AM
  2. Replies: 2
    Last Post: 07-12-2016, 10:57 PM
  3. Replies: 4
    Last Post: 03-17-2016, 12:42 PM
  4. Replies: 7
    Last Post: 10-25-2014, 10:41 AM
  5. Updating Table field from Form
    By Kunuk in forum Access
    Replies: 0
    Last Post: 02-26-2009, 11:41 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