Hi All...
I have a table called Furnishings
Furnishings
||ID||Name||specLink||
speckLink contains a link to a PDF
eg a set of 3 records
||1||XO corner cove||C:\specs\xocc.pdf||
||2||GD mid link||C:\specs\gdml.pdf||
||3||key backer||C:\specs\kb.pdf||
I have a split form for this table, where i can obviously add and view records.
What i have been trying to do with no luck is create a button on the form that when clicked will open the respective pdf for the selected record. i understand that you can specify a hyperlink but the value remains static. i want it to be dynamic so the link changes dependant on the record selected.
Im not good when it comes to coding, so would really appreciate some advice or guidance on this.
Thanks.
Julie
I have a table called Furnishings
Furnishings
||ID||Name||specLink||
speckLink contains a link to a PDF
eg a set of 3 records
||1||XO corner cove||C:\specs\xocc.pdf||
||2||GD mid link||C:\specs\gdml.pdf||
||3||key backer||C:\specs\kb.pdf||
I have a split form for this table, where i can obviously add and view records.
What i have been trying to do with no luck is create a button on the form that when clicked will open the respective pdf for the selected record. i understand that you can specify a hyperlink but the value remains static. i want it to be dynamic so the link changes dependant on the record selected.
Im not good when it comes to coding, so would really appreciate some advice or guidance on this.
Thanks.
Julie