Hello.  I am trying to setup a command button on a form that will
allow me to assign a hyperlink that will automatically open a file
(word, excel, pdf, etc) when I click on it.  However, I am unsure how
to setup the code that will allow me to create the hyperlink.  So far,
I have a field (FileHyperlink) in my table (ExpensesMain) that is
setup as a hyperlink field.  Is there a way to have a command button
open up a dialog box that I can search for the file I want to assign,
select it, and have it assigned to the tect box on my form (Text box
name: txtFileHyperlink - Form Name: ExpensesDetail)?

Thank you.