Hi Everyone

I have a table with suppliers details and a table of their contract details. In the contracts details table there are 20 different terms & conditions which the user can view etc warranty and terminatiion. As well as this I want the user to see the complete original contract.

I know you can load word from a form but everytime I do this it opens a blank document. Is there anyway I can type in the actual path to open the document I want?

Also baecause there will be many contracts for every supplier and many suppliers on the database I am not very sure if this will be the best way to go about it.

I currently have all 20 fields on the one form called complete contract but as this is not the original document this is no good.

Can anyone offer some advice?
Thanks again for all your help so glad I found this site!

You could add a hyperlink field to your table and then to your form. To insert the link to the correct file right click on the new field (or control, which ever you like to call it) and select the document you require to be open.
Hope it helps,
Dave

[This message has been edited by Oldsoftboss (edited 12-13-2001).]

That did the trick.

Cheers for that Dave.

The way I have the hyperlink set up just now opens the folder where all the original contracts are stored and then I can select the one I want to open in word.

If I wanted to create lots of hyperlinks on my form and place them beside the contract ID and open these contracts from here would this take up too much memory? or am I best to keep it the way I have now?