Combobox Controlsource from an Access Query

[JShowalter]

I have a combobox on an excel userform.
Can I use an Access Query as the controlsource for the combobox?

Thanks

 

[Joseph R. Pottschmidt]

The only way to do that is you have to link to that Access database and
import that data into an active worksheet on your workbook. There isn't
as of yet a way to link directly to MS Access query as of yet.

-----Original Message-----
From: (e-mail address removed) [mailto:[email protected]]
Posted At: Friday, May 26, 2006 8:37 AM
Posted To: microsoft.public.excel
Conversation: Combobox Controlsource from an Access Query
Subject: Combobox Controlsource from an Access Query

I have a combobox on an excel userform.
Can I use an Access Query as the controlsource for the combobox?

Thanks