Results 1 to 4 of 4
  1. #1
    templeowls is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    305

    Bind text box to combo box


    I have a combo box that has a list of locations. In the table that contains these location names (which is the basis of this combo), there's also the location address.

    I'd like for when someone selects the location name, the text box to the right populates the address.

    I have no idea how to bound the two though

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Add the address as an extra column in the combo. Set the column width to zero if you don't want it shown.
    Then set the text box record source to e.g. Me.comboboxname.Column(1) if the address is the second column .... (numbering starts at 0)
    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
    templeowls is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    305
    Ok, how do you go about adding a second column to a combo box?

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    In design view, select the combo then open its property sheet.
    Set the Column Count =2 and set the column widths to 2.5cm;0cm or similar.
    Make sure the bound column=1
    Now select the Row Source property. Select the small ellipsis button with … and add the address field as the second column.
    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

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

Similar Threads

  1. Bind Combo Box on Order Form
    By JJHeck in forum Forms
    Replies: 4
    Last Post: 05-16-2018, 02:48 PM
  2. Replies: 7
    Last Post: 09-10-2014, 06:56 PM
  3. Bind one combo box to another one
    By Zamani_2012 in forum Forms
    Replies: 1
    Last Post: 08-12-2012, 09:51 AM
  4. Bind item() to button text at random
    By timosilver in forum Access
    Replies: 0
    Last Post: 02-26-2012, 12:08 PM
  5. Text Box Won't Bind
    By HowardOfOcal in forum Forms
    Replies: 10
    Last Post: 01-30-2012, 02:57 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