Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Location
    Glasgow, Scotland
    Posts
    7

    Question Unanswered: retrieving SQL data from access

    What is the best way to retrieve lookup data from SQL into combo boxes and lists in Access. Should I use the rowsource as a table/query or is it better to use an ado recordset to populate a value list.

    thanks

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    IMHO, I would go with the recordset/value list and a stored procedure. The stored proc will insulate you from the database.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Dec 2002
    Posts
    63
    A pass through query would work if you wanted to do it all on the access end.

Posting Permissions

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