Please Help!!? View Hyperlink using command button.

[Guest]

Please guys I really need your help on this one!
I have a database in which each record has a hyperlink to a Word document. I
would like to have a form in which the user can type in a number that brings
up the relative record and then click on a command button that will
print/preview the Word Document.
Your help will be greatly appreciated!

 

[Guest]

Try this link

http://www.accessdatabasetips.com/open-word-excel-file-from-button.html

To bring the path and file name, you can use Dlookup
=Dlookup("FieldName","TableName","numberField =" & Me.NumberField)