.hyperlink information from within a subform

[voodooca]

Hi Everyone,

I have just created a hyperlink from within a simple form that I have to pull and open a PDF file that matches with a customers order.

My code is below:

FollowHyperlink "\\Frontdesk\FrontDesk\PDFOrders\" & Order & ".pdf"

That works great - now I have a challenge, and I dont think it will work, but I am not the greatest with the programming end of things, so I wanted to ask.

I have a form that shows each customer, then a subform that only shows orders from that customer. As you can imagine customers may have 1 order or 5...

Can I use the same idea for hyperlink as above on the form and still get Access to open the orders for a customer from within the subform?

I simply tried putting the same code on the main area of the form, but as I expected it doesnt look in the subform. Even if I could get it to look in the subform, what happens when it sees 2 or more numbers in the "order" column?

I have added a picture incase that helps.

Any help is appreciated!

Chad

[NeoPa]

Check out How to Programmatically Create a Hyperlink on a Form. It could be easier than you think.

[voodooca]

Thanks Neo, I will take a look.
Does that mean you know/think what I want to do is possible?

*UPDATE* - Ok, so I took a look at that thread you referenced... I dont have any programming background so I am seriously struggling with understanding what each of those lines will do. Classically I have copied programming that I have found somewhere and manipulated it slightly to accomplish what I need (Like the hyperlink example above) but my instincts are telling me that without some more background lessons, deciphering that code is a little above my pay grade. :)

Chad

[NeoPa]

:D

To be honest, that wasn't the thread I thought I was linking you to. I need to dig up something I did a while back that made creating these links for a form perfectly possible just in the query itself. Generally speaking, no code required.

[voodooca]

Oh, no problem - I appreciate the help.
I was having issues just getting the simple one working today over the network, but I resolved that. Now I just want to see if I can make it pul multiple orders.

Thanks for the help!
Chad

[NeoPa]

What I thought I was posting was Error 7980: HyperlinkAddress or HyperlinkSubAddress read-only for Hyperlink.

[voodooca]

Thanks Neo!
I will take a read over that and see if it is easier to understand.

Chad