Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    47

    Unanswered: Combo-Box Problems .... Please Help

    I have a combo-box that displays 2 columns

    SupplierID (key and not displayed),
    Supplier Name,
    Contact Title-Contact First Name-Contact Last Name

    The Contact Title, First Name and Last Name are all joined together into one column (using & " "& )

    After selection I want the Title, First Name, Last Name colum to be displayed.

    I'm sure there must be a simple way to do this, but I cant get this to work.......please help

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Combo-Box Problems .... Please Help

    Originally posted by Anduril
    I have a combo-box that displays 2 columns

    SupplierID (key and not displayed),
    Supplier Name,
    Contact Title-Contact First Name-Contact Last Name

    The Contact Title, First Name and Last Name are all joined together into one column (using & " "& )

    After selection I want the Title, First Name, Last Name colum to be displayed.

    I'm sure there must be a simple way to do this, but I cant get this to work.......please help
    Check this thread out ... http://www.dbforums.com/t989990.html

  3. #3
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    Here . . .

    Bind the rowsource to a query with the following output, in this order:

    Contact Title-Contact First Name-Contact Last Name
    Supplier Name
    SupplierID

    Set the bound column to be 3 (that's the SupplierID)

    Set the number of columns to be 3.

    Set the listwidth to be, say 3".

    Set the columnwidths to be 0.0007";2.9993";0

    0.0007" seems to be the smallest column with the combobox control can use, and still recognize it as a column. But at that size it is effectively invisible. So, when you pull this thing down, you will get list of supplier names, but when you let go, the display will show your catenated contact field. The bound key field will remain hidden through the whole process.

    Basically, the Access combobox will display the calue in the first column, but you can hide that first column from the pulldown by using this trick.

Posting Permissions

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