Hi,
I have a data base form that captures information off a physical form using a simple vba program. The physical form, once signed off, needs to be scanned and saved to a network folder. When the clerk is capturing the form in VBA, I would like them to be able to add a link to the copy of the phyisical file saved in pdf on a network folder.

Currently, the form opens and dates are captured, people, departments etc, the the last one would ideally say PDF copy. They would hopefully be able to navigate to the folder, select the file and then back to the form. When clicking save in the form, the date is column 1, the name column 2 etc, all cptured from textbox controls. The last column, in my case, N, would hopefully be a hyperlink to the pdf file that was scanned before capuring the information off the physical form.

I am struggling to explain clearer.

Is it also possible to add a print button, that could print a blank pdf copy of the form in question? That would be ideal.

Thank you.