Constructing a Hyperlink address

[DorisL]

I had a question to come up in one of my classes that I couldn't answer....

Is there a way to use another field value as part of the hyperlink address in a hyperlink field? (For example, the value of the field on the current record might be the name of a query to which we would want to link.)

Do we have to use code to set the value of the hyperlink field?

 

[mcadle]

You can use another controls contents in a hyperlink situation. However, in the situation you described, you are probably better off to use:

docmd.openquery "queryname or the path to the textbox"
In the textbox the user could put the query name to run if the knew it.

or

CurrentDB.execute "same stuff as above"

Now, I do use a textbox to open a file via hyperlink. I have the EU type in the name of the word file that they wish to open in the textbox. Then I have a command button to execute.

Hope this helps and answers your question.
Good luck

 

[DorisL]

Thanks, Mark
I will offer your suggestion as a solution to the question. I didn't like the idea of using a hyperlink for that purpose but I did need to answer if it was possible. (The class was just learning to use hyperlinks.)