Ok here’s what I’ve got. We’ve designed a database for our engineering staff to use to keep track of open projects and the like for themselves. What we have is a simple Access 2000 format database, with a few very simple macros and queries. What I can’t figure out is a way for Access to open up the drawing files from the table when a query is ran. For example, say an engineer pulls up the query CAD drawings button, which runs a query for them on the Key Field of the central Table, and pulls up a person who has four different drawings. What I want them to be able to do is to be able to double-click the drawing number, and for access to open the file in the CAD software based on the drawing number. I know it can be done, a previous programmer did it for an older drawing database, but I can’t get his code to work either right now. Any Ideas??