Raading from a file to populate a drop-down

[Adam Pelled]

I would like to read from a file to populate a drop-down list box.

It is for use in a form that files details of research notes from stock
brokers. I would like to be able to chose from a drop down list of stock
brokers (e.g. Merrill Lynch et al) but obviously that list will change over
time.

Currently it is just "hard-coded" in the form design, but I would like it to
be able to pull the data from a text file or something similar on a hard disk
for instance. Failin g which if it can be stored in a "post item" in a folder.

How can this be done?

TIA
Adam

 

[Adam Pelled]

To answer my own question. Found response to similar question from S Mosher.
If there is an easier answer please let me know.


Yes, but you'll need to write the code (usually ADO) to access the database.
See http://www.outlookcode.com/d/database.htm and
http://www.outlookcode.com/d/formcontrols.htm#listcombo for examples and
other resources.