I have a table which contains details of contacts with clients, ie letter/emails. If it is possible I would like to be able to click on the record of contact which is viewed in a subform, and for Access2000 to open this letter which corresponds
Also, the user requires this to be done automatically so that everytime there is a form of contact they have access to it at a later date.

I hope I have explained myself clearly

Thanks in advance as this is really puzzling me

Lorraine

Using a command button and the Hyperlink Address event you can open Word documents and other items. Search Help for Hyperlink Address property for more information...

HTH,
Jack