hyperlink from form to a file specific to the record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Howdy all, I'm trying to put a command button on my Form to create a link to
a file directly related to that record. It's a Prospective Hires Database,
and I want the command button to open the applicants resume, which i have
saved to a subdirectory. All I seem to be able to figure out is how to link
to the same file from every record, whereas I want to link to the file
directly related to the name in the record.
 
I don't know how your Prospective Hires table is defined, but adding a field
to the table that has the data type hyperlink is what you need.

When you create a record for a Candidate, you need to save the path and
filename of the resume to that field.

Then, the Click event of the command button, you need the code to open that
specific file.
 
Back
Top