Passing form value to hyperlink address

[Macro condition based on date]

How do I append a form field value to the end of a hyperlink address that is
coded as a hyperlink address on a form label?

 

[Arvin Meyer [MVP]]

"Macro condition based on date"

How do I append a form field value to the end of a hyperlink address that
is
coded as a hyperlink address on a form label?

How about something like this in the form's Current event:

Private Sub Form_Current()
Me.lblWhatever.HyperlinkAddress = "C:\Data\" & Me.txtTextbox
End Sub

 

[Macro condition based on date]

Do not understand how this would pass (append) a filed value to the hyperlink
address when I click on the label that contains the hyperlink address.

 

[Arvin Meyer [MVP]]

By referring to the HyperlinkAddress property of a label in the form's
current event, you make that label into a clickable hyperlink. The label can
read anything, but when you click on it, it will link to the document at
C:\Data\ and whatever file name is in the textbox. If the resultant value is
not readable, it will open a Windows Explorer window to the default location
that Access has in its Options.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Macro condition based on date"