Combobox Controlsource from an Access Query

J

JShowalter

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

Thanks
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combobox 4
Bring Data From MS Acess in a Combobox 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Query Parameter using multiple options 0
DataSource for ComboBox in UserForm 3
Date as a value to a textbox as a result from another textbox 1
How to open a specific worksheet via code from workbook_open 1
How to open a specific worksheet via code from workbook_open 5

Top