Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941

    Unanswered: PASS-THRU Queries

    I am attempting to use a pass-thru query in the RowSource for a combo box.

    Code:
    SELECT PRODUCT, PROD_DESC FROM MYPASSTHRU WHERE PROD_LINE=[CMBPRODLINE]
    CMBPRODLINE is another control on my form.

    For some reason, it repeatedly asks me for the DSN. Any way I can't make that go away? I don't think my users will be able to work with that.
    Inspiration Through Fermentation

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Does it ask for the DSN when you run it manually?
    If you go to the properties of the pass through and check the ... (connection string property? I forget)..... you should be able to just stick in an ODBC connection string.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    That did it. You da man!
    Inspiration Through Fermentation

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Oh how splendid! I always wanted to be one of them
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Scratch that....
    You da flump
    Inspiration Through Fermentation

Posting Permissions

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