Thanks! Very helpful. To clarify, suppose the field name on the form is called ID, then using your code...
varFile = "X:\dir\desiredid\Database Files\" & ID & ".pdf"
Hello,
I hope this is a simple question that I can get some help with. I have a table full of individual ids and some associated information. For each individual is a .pdf file on my hard drive. I've created a form which displays some information about the individual id and on this form, i'd...