Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Walnut Cove, NC
    Posts
    101

    Unanswered: Combo Box with 3 fields from a table

    I have a combo box in a form that I want to show 3 fields in:

    Part_Prefix, Part_No, Part_suffix.

    I am using the Select statement to get the information for the combo box. When you click the arrow button on the combo box you can see all three fields. However when you select one of the records listed, it only selects the first column. I cannot figure out how to get the combo box to select all three fields.

    Please help.

    Thanks,

    SBR

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

    Re: Combo Box with 3 fields from a table

    Originally posted by sbr7770
    I have a combo box in a form that I want to show 3 fields in:

    Part_Prefix, Part_No, Part_suffix.

    I am using the Select statement to get the information for the combo box. When you click the arrow button on the combo box you can see all three fields. However when you select one of the records listed, it only selects the first column. I cannot figure out how to get the combo box to select all three fields.

    Please help.

    Thanks,

    SBR
    Comboboxes display ONLY the 1st visible column ... If you want the display all 3 items, they will have to be concatted together into a single column ... You can do this AND have the items in separate columns ... Just display only the combined items column ...

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1

    Re: Combo Box with 3 fields from a table

    n/m Owen said it better.
    Last edited by Teddy; 03-23-04 at 11:02.

  4. #4
    Join Date
    Jan 2004
    Location
    Walnut Cove, NC
    Posts
    101

    Re: Combo Box with 3 fields from a table

    Originally posted by M Owen
    Comboboxes display ONLY the 1st visible column ... If you want the display all 3 items, they will have to be concatted together into a single column ... You can do this AND have the items in separate columns ... Just display only the combined items column ...


    Thanks, I will give that a try tonight.

    SBR

Posting Permissions

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