Raading from a file to populate a drop-down

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam Pelled - 24 Sep 2005 07:40 GMT

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

Reply to this Message

Adam Pelled - 24 Sep 2005 07:59 GMT

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.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> I would like to read from a file to populate a drop-down list box.
>
[quoted text clipped - 11 lines]
> TIA
> Adam

Reply to this Message