I have a form with a subform. In the subform I have several fields to
which I am assigning links to documents on the file server. I learned
(from this list :-) how to add the links. Because I will be executing
the code for four or five fields, I would like to have a generic
subroutine to pass the field name parameters to. I have searched and
tried many formats and syntaxes for this with no success.
Here are the principle lines from the routine that I wish to make more
general
lnkApplication = varFile & "#" & varFile ' puts the hyperlink in the
field.
lnkApplication.Visible = Not (IsNull(lnkApplication.Value)) ' only
shows the field on the form if it has a path in it
lnkApplication is the actual name of the field in a table called
tblFamilyMembers.
Please help me with the syntax to pass the fieldnames to a general
subroutine and to modify the lines above. Also, please let me know if
there are any additional lines of code needed to make it work.
Thanks,
Bernie