How to automatically link a hyperlink field based on other field in the same record?

[stalk]

I've a vendor field and would like to auto-populate the record_location hyperlink field to point to that vendor subfolder when a new record is entered. This is to see any related documents from that vendor. Is that possible? If so where should I give that.



I don't want to attach any document but would like to have hyperlink in that record, pointing to that path.

Thanks in advance.

[jwhite]

If record_location is going to be "auto-populate"'d, why can't you use a double-click event (for example) on vender to open Windows Explorer to that folder? Then you wouldn't need the record_location field at all.

example: Shell "C:\WINDOWS\explorer.exe """ & Foldername & """", vbNormalFocus

[Bulzie]

OnClick of button or AfterUpdate on field. If the path needs to be the value of another field, then build it in code.

Application.FollowHyperlink "C:\YourFolder"
or
Application.FollowHyperlink "C:" & me.VendorName

[Micron]

Suggest on the AfterUpdate of the vendor control, you set the hyperlink control value by using DLookup to get the path. This assumes you have a path field and vendor field in a table or query from which you can retrieve the path according to the vendor value in the vendor control.

[Bulzie]

Could also do something like this with a label:

Me.Label4.HyperlinkAddress = "http:\\www.cnn.com"
Me.Label4.Caption = "cnn"

[Micron]

I think the property is label.Hyperlink and not label.HyperlinkAddress?

[Bulzie]

When I tested it needed HyperlinkAddress but he can try it and see what works.

[Micron]

Thanks, I was just going by what the object browser and Access help states.

[stalk]

You guys Rock!!!!! My issued is fixed. I used the following code to update my hyperlink field automatically in FORM as well as table based on vendor..

Private Sub Vendor_AfterUpdate()

Me.service_rec = "#" & "c:\Service_Records" & Me.Vendor & "#"

End Sub