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.
thanksIMHO, I would go with the recordset/value list and a stored procedure. The stored proc will insulate you from the database.|||A pass through query would work if you wanted to do it all on the access end.