Need to Hyperlink to URL from form query

[Sherri726]

I have a form generated by query using a text both with an expression which is a combination of two fields. I want to give the user the ability to click on the text and go to a url. The urls are stored in a another table.

tbl1
schedno
URL

qry (tbl2)
expr [schedno][subitem]

I just don't know how to go about setting up the text box on the form for the on click.

Any help appreciated.

 

[Remou]

I suggest you use double-click. Click can be a nuisance. I think you need to look at FollowHyperlink.

 

[Sherri726]

Thanks. The FollowHyperlink works, but the path has a "# in the front and behind the path. I know this is related to the setup of the hyperlink field.

How do I call out the address only to get rid of the "#?

I also get a warning message about "hyperlinks can be harmful etc". How do I stop the warning message?

 

[Remou]

I am afraid I have misunderstood you. Can you post a sample of the data?