Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    5

    Unhappy Unanswered: Combo Box problems

    Apparently, there was a problem with the first post.

    What I need is a combo box that is a combination of
    "I want the combo box to look up values in a table or query"
    and
    "I will type in the values that I want"

    For example, the combo box called "Pick a color" should get its values from the table PLUS contain "No Color" and "Fuchsia", just in case the first person who wants to use this color doesn't know how to spell it. Just a dumb example.

    Is this possible?

    Thanks in advance!

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Hi,

    Use union query as a datasource for your combobox.

    SELECT ColorCode, ColorLabel FROM tblColors;
    Union
    Select ColorCode, ColorLabel from tblAdditionalColors;

    where tblAdditionalColors has the same structure as tblColors and contains additional items for your combobox.

    Igor

  3. #3
    Join Date
    Jul 2002
    Posts
    5
    After having some trouble posting to the forum, I just read your solution now, and it worked. Thanks a lot!

Posting Permissions

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