Hyperlink on forms

[hjgoldstein]

Hi guys.

I have a silly problem which is baffling me.

I have two forms - one single form view, one continuous forms view.

The single form has a tab control.

I have a hyperlink text box control on the continuous form and an identical one on the tab control of the single form.

The hyperlink on the tab control only works if the sub-menu item "Hyperlink > Open Hyperlink" is used. If I click on the control, the system inserts a "#" before and after the url and then does nothing else. If I put the text box control in an area of the form outside of the tab control, it works fine.

Any ideas?


It is time for pacifists to stand up and fight for their beliefs.

 

[kjv1611]

Hmm, it may be easier to just use a different control object. Can you use a label instead, with the link on the label?

 

[kjv1611]

BTW, that may not work, I don't honestly remember off hand if you can link from a label.

Another method, using the text box, might be to change it to locked (not updatable), and that way nothing can be added to the text box? Well, that'd be a fixer way around that piece of it, but it may not fix the hyperlink issue itself.

Is there any code behind the On Click event of said text box? Or else, is there any On Current code behind the form, or the tab control? Or On Change?

 

[hjgoldstein]

kjv1611

No, I tried this before but you can't set "Is Hyperlink" in a label.

You can assign a hyperlink address relating to an "Object in this Database" but only to a table/query/macro etc level.

I tried setting up a query containing only the field I need, but this opens the query in full.

I may have to resort to putting the hyperlink control on the detail area of the form rather than in the (more appropriate) tab



It is time for pacifists to stand up and fight for their beliefs.

 

[kjv1611]

I don't think you understand what I meant by the query - I didn't mean to build a query, then have the on-click even open it...

Do this...

1. Create a New Combo Box
2. In the Combo Box Properties, select the table that has the value you want to grab.
3. Next, click the build button - button with 3 dots on it, to the right of the table name in the combo box's properties.
4. HERE is where you build the query to only return what you need. For the criteria, you sat it's ID field equal to whatever ID field is listed on your form, I dunno, txtID or whatever it is that you are using as the ID field for the form's main recordsource.

 

[hjgoldstein]

kjv1611

I don't see where you mentioned query in your previous posts, but never mind.

I tried what you said in your last post, but no joy there either.

I appreciate your help.

It is time for pacifists to stand up and fight for their beliefs.

 

[kjv1611]

Good catch. I must have been dreaming or something when I said that (query). I must have been dreaming about mentioning the use of a query.

....

Hmm, I think somehow I got mixed up, mixing the questions (in my head) from 2 different postings.... yours has nothing to do with a query.

Now, I shall go hide in the sand.