Hello,

I have a Access database, CARS.mdb, and an excel file, CARS_SURVEY.xls
Inside of CARS_SURVEY.xls there is a form. It has an ongoin
connection to the CARS.mdb database. Is there a way I can tell th
form to use the database table 'Shops' and colomn 'Shop_ID', for a dro
down inside the form on CARS_SURVEY.xls?

Ex.

CARS.mdb has a table, Shops and inside Shops is 3 colomns. I want th
colomn 'Shop_ID' to be used as the list source for the dropdown list
Shop_ID on the form CARS in the excel file CARS_SURVEY.xls...

Any help provided is greatly appreciated!

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=47772