Results 1 to 2 of 2
  1. #1
    tanyapeila is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Posts
    42

    Angry Bound Columns

    I don't know why I have such issues wrapping my head around Bound Columns.

    My typical table has ID, NAME, ADDRESS, etc, etc,

    When I use a combo box I want The "Name" column to be the bound column. Problem is I ALWAYS get the ID#!

    I am entering Bound column: 2.

    I just don't get it.



    HELP!

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Comboboxes have several properties. The bound column property is used to assign one of the columns from the Rowsource to the .Value property of the combobox control.

    Another way to retreive a value from a combobox os to use the Column property. Me.ComboName.Column(0) or Me.ComboName.Column(1) or Me.ComboName.Column(2)

    Dim strMyString as string
    strMyString = Me.ComboName.Column(1)
    debug.print "The second column = " & strMyString

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

Similar Threads

  1. Replies: 6
    Last Post: 01-30-2014, 05:57 PM
  2. Replies: 7
    Last Post: 12-06-2013, 03:11 PM
  3. Bound columns in Forms and resetting values
    By Daryl2106 in forum Access
    Replies: 3
    Last Post: 01-29-2013, 02:37 PM
  4. Bound form with bound combobox
    By Jerry8989 in forum Access
    Replies: 2
    Last Post: 12-05-2011, 01:50 PM
  5. Replies: 1
    Last Post: 04-19-2011, 04:46 PM

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