Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box list (2003)

    Hi,

    I have a combo box on a form and the combo box's row source is a table call tblList. The tblList have two columns, one is ID and another one is Name. Now, combo box is only listing the value if user enters ID value. However, I would like the combo box list any data that includes whatever user enters either ID or name. For example, there's a data in tblList is 1112345 (ID); ABC(Name). If user either enter "12345" or "BC", this data will appears in combo box.

    Thanks in advance.

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: Combo Box list (2003)

    Combo boxes don't work that way. If you want the user to be able to enter a name, hide the first column by setting the Column Widths property of the combo box to something like 0";1". But then the user won't be able to select an item by entering an ID.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box list (2003)

    Thanks, Hans.

Posting Permissions

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