Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    228

    Unanswered: Populate combo box with query from two tables

    I have a combo box (1 column) that I want populated from two tables.
    I have query1 that gets the data from table1 and query2 which gets the data from table2. How do I populate the drop down list with the contents of query1 followed by query2 results?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    SELECT t1.column
    FROM t1
    UNION
    SELECT t2.column
    FROM t2
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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