Community
Showing results for 
Search instead for 
Do you mean 
Reply

Where to find drop down lists in Access

Avid Listener
Posts: 20
Country: Denmark

Where to find drop down lists in Access

Hi,

 

 

I've managed to setup a ODBC connection with ACT Reader, but I have a very hard time finding a table with all the drop down lists. So far I've only found the defined fields but not the drop-down lists which is used by some of the fields.

Moderator
Posts: 4,395
Country: USA

Re: Where to find drop down lists in Access

You can find them in TBL_PICKLIST AND TBL_PICKLISTITEM.

 

TBL_PICKLIST contains the drop down list name and picklist ID

 

TBL_PICKLISTITEM contains the values.

Platinum Elite Contributor
Posts: 14,387
Country: Australia
Platinum Elite Contributor
Posts: 14,387
Country: Australia