I asked this same question yesterday and received four recommendations which I accepted as solutions before testing (not a smart move on my part). Right now I'm trying the one from als315 who stated: "Test this sample: DBHyperlink.accdb 388 KB." So far I haven't been able to get it to work. I have a couple of questions abut the sample form:
1. I notice that the text box and the command button are using the exact same VBA code (shown below). Why is that?
Private Sub Command21_Click()
Me.LabelH.HyperlinkAddress = Me.Field1
2. I know that I need to replace "Field1" with my own field name, but is there anything else I need to replace, e.g., "Me" and/or "LabelH?"