Source an Access Table for a dropdown list box

[Guest]

I am wondering if this is possible... any advice would be appreciated

I want to put in a drop down list box in my worksheet. Instead of sourcing from a range of cells, I would like to source from an Access Table. Is this possible, if so how

Thank
Trina

 

[Ed Ferrero]

Hi Trina,

Go to the menu item Data - Import External Data - New Database query
Follow the prompts to place a data range in your worksheet
Go to Data Range Properties and rename the Data Range to something simple
like 'MyQuery'

Using the Controls toolbox place a drop-down in the worksheet, then edit the
properties to
set the ListFillRange to 'MyQuery' (without the quotes)

OR
Using the Forms toolbar - add a combo box to the worksheet, then Format the
Control to
set the Input Range to 'MyQuery' (without the quotes)

Ed Ferrero
http://edferrero.m6.net

I am wondering if this is possible... any advice would be appreciated.

I want to put in a drop down list box in my worksheet. Instead of

sourcing from a range of cells, I would like to source from an Access Table.
Is this possible, if so how?