I have an access database that I am creating cataloging some class rosters that are in .pdf format. I have created a table that show the basic file location of the rosters. Each roster has a unique activity code. I tried to create a query that a form can use to take the basic file location and concact the activity code from a user input so it will create the link directly to the file. I am unable to make the field in the query or in the form into a link? Any help on how I can do that? I have been playing around a bit and found I can create a form from a table that has the full file address including the activity code that I can link and open the file. I really want it so the user can specify which activity code and be able to get the link for that specific. I don't want to really add a link to every activity code in a table. An example, I teach a class called "apples". The rosters for apples are in c:\apples. I want to enter the activity code for a specific apples class and concact the information to show as a link in a form such as file://c:\apples\activitycode.pdf