You'll first need to define a Data Connection (using the Data View palette) to your table in your Access data base. In order to do this, you'll need to setup an ODBC data source pointing to your Access data base. Once of the steps in the configuration of the Data Connection will be a window asking you to pick the record source to use from the ODBC connection. You'll have the choice between
Table,
Stored Procedure and
SQL Query. If you pick,
SQL Query, you can then specify an SQL statement that'll retrieve all the information from your table in a sorted fashion:
SELECT * FROM
TableName ORDER BY
ColumnName ASC
Note that you can also use DESC instead of ASC to sort in descending order.
Then I would suggest that you use the Data Drop Down List object found in the Library palette's Custom tab. You'll need to configure its Initialize script to specify the name of the data connection to use as well as the names of the text and value columns from the data connection (table column names).
Please let me know if you have any questions.
Stefan
Adobe Systems
