Results 1 to 3 of 3
  1. #1
    jgelpi16 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544

    Question Isolate Column in Combo Box


    I have a combo box where the user has to select the state. The combo box has the state spelled out in column1 and the state abbreviation in column2. When the user selects a state I want the column1 value to update the state field in my table and the column2 value to update the stateabrv field in my table. I know how to do one or the other by bound columns, but I need both to be updated at the same time. Any insight on this will be much appreciated.

  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
    For starters, you generally shouldn't store both, just the key value (the abbreviation). If you insist, this in the after update event of the combo:

    Me.BoundTextboxName = Me.ComboName.Column(1)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    jgelpi16 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Thank you, that worked.

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

Similar Threads

  1. Replies: 7
    Last Post: 04-27-2010, 02:47 PM
  2. Replies: 1
    Last Post: 04-15-2010, 02:07 AM
  3. Replies: 1
    Last Post: 08-26-2009, 10:45 AM
  4. Replies: 0
    Last Post: 08-17-2008, 12:19 PM
  5. inserting values in column based another column
    By wasim_sono in forum Database Design
    Replies: 1
    Last Post: 06-27-2006, 05:23 AM

Tags for this Thread

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