Thank you, Cari
Edited to add a bit of the code I am using and what happens when I run the search.
This is the code I am using in a text box on the resource form. Links is the name of the field in the articles table that holds the link. ID is the name of the field in the articles table that the specific link needed is, articlecombo is the name of a drop down box in the search form that holds the article id. After you choose the specific article you want based on your search parameters you click a button that opens the resource form. =DLookUp("[Links]","Articles","[ID] = " & "[Forms]![Search]![ArticleCombo]") This is what I get instead of the actual link after the search is run and the resource is shown. #C:\Users\Mami\Documents\TestAttachment.docx#
This post has been edited by mysticmayhem: 05 March 2009 - 08:24 AM