Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Posts
    107

    Unanswered: filling a combo box with a db list

    hi there.
    i have 2 tables - one called users with the PK being username.
    the other table is a called participants and it has a username field too. i'd like to populate participants.username with the values from users.username. On the form, I'd like the combo box to display the "FULL Name" but save the associated "username" in the database.

    I've tried to create a combo box on my form that has the following properties:
    controlsource=Users!FullName
    rowsource = SELECT DISTINCTROW users.* FROM usersORDER BY users.fullname;
    boundcolumn=1

    the table design for users looks like this:
    username PK (text)
    fullname (text)
    title (text)

    When the form loads, its filling the list with the usernames, instead of Full name and when I try to select one, i get the following error:

    "Control can't be edited; it's bound to the expression 'Users!Fullname'"

    Can you tell me what i'm missing / what I messed up?

    Thanks.

  2. #2
    Join Date
    Aug 2006
    Posts
    559
    dotolee,

    What does the other table look like? Can you post a zip of your db so we can look at it?

  3. #3
    Join Date
    Feb 2003
    Posts
    107

    posting db

    i can't post the db because it contains confidential data.
    The table def for the second table includes a field called
    "TCName" that is a text. I haven't created a relationship between these two fields but... i don't think that would / should have an impact...

    Please and thanks.

  4. #4
    Join Date
    Feb 2003
    Posts
    107

    table def. attached

    I took screenshots of the table defs... if that'll help.
    Attached Thumbnails Attached Thumbnails recruit.bmp   users.bmp  

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Since the problem is that the Users!FullName reference is read-only, change the Control Source to the field you want to store the results in. Use the combo box for the Control Source to PICK a field (username) from the list.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •