How to populate combo box with files from outside folder and display chosen file

[charles.kendricks]

I would like to populate a combo box on a patient form with file names
of files from a folder outside the database. The file names would
match a pattern drawn from the patient first and last name (which could
be derived from the original form). These files from the outside
folder consist of scanned images of patient records.

Then I want to be able to display, with the associated application, the
selected file by choosing it from the pull down list of the combo box
(or list box) from the original form.

Please keep in mind that I am real novice at VBA, so as detailed an
explanation as possible would be greatly appreciated.

 

[Arvin Meyer [MVP]]

You'll need to put the file names in a table. You can do that by altering
the code samples at:

http://www.datastrat.com/Download/DocMgr_2K.zip
http://www.datastrat.com/Download/Picture2K.zip

I would then link the patient names to the files and use a combo box to
choose them.