is there a way to add hyperlink fields dynamically to a form?

[tbrown7777]

i have a list of files and their directory in a table. i would like to
display a hyperlink on my main form only if there are files associated with
it. meaning the number of files could change....

thanks.

 

[Dale Fye]

I usually do this via a subform.

Since the subform would require a field in both the main form and the
directory table that would filter the directory, this would make sense, and
would only display the records from the directory which match the record on
the main form.

When I do this, I generally make the subform a continuous form, and put a
button (Open) in the subforms footer which is only enabled if the subform has
records. When the user clicks the Open button, it executes the
"followhyperlink" method and reads the hyperlink address from the selected
record in the subform.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.