Help! I don't know how to assign hyperlinks from table records to form labels using VBA code

[Britsical]

Hello, I am a self taught access user trying to build a simple database to act as a central repository of information for our projects dept, basically to replace a 102 column excel spreadsheet. We have a number of live projects, each one has a set number of supporting documents stored in individual project directories on our intranet.The Excel spreadsheet had columns of schedule data, cost data, resources and general references, so I have split this data into four tables (schedule, cost etc) with a direct relationship based on unique project ID numbers in each table. So, each project in the general reference table have a direct one to one relationship with corresponding fields in the other tables. One of these tables contains fields with hyperlinks to the locations of the projects supporting documents.



I would like to create a form with the supporting project documents represented by labels. As the user moves through the projects (different records in the projects list) using the navigation buttons I would like to assign the correct hyperlink for that specific project directory to the labels. I have tried using macros, code builder and text fields instead, but I can't get this to work.
Ideally I could display the label as an hyperlink IF the corresponding hyperlink field was populated, and only load the correct hyperlink and follow it when the label was clicked. However that is the ultimate dream, and I would be very happy with any method that can assign hyperlinks on the fly to these labels. Can anyone help please?

[June7]

Why don't you just use a textbox bound to the field?

Programmatically setting properties of controls in form set to Continuous or Datasheet view won't work. The property setting is reflected in all records.

[Britsical]

Thanks for the quick response June7. I could use the text box bound to the field and use the attached label to indicate the document type. I was trying to make this more professional looking, i.e not showing the hyperlink, only the
document name. However, after six hours of trying various ways to achieve what I want I think the simplest approach is probably the best.
Thanks June7!

[June7]

How is the hyperlink stored? In a hyperlink field? Review http://www.allenbrowne.com/casu-09.html