Hello,

I have inserted an Word Documents as an object into a tab on a form.

How can i link this form to the "Card Number" field which is the primary key in my database?

I want an individual word document made for each record i have in my database.

Currently, the properties of the OLE object is in the picture below:
http://img88.imageshack.us/img88/4494/78845283bw6.png

Also, i noticed the name of the OLe object was OLEunbound331, is there any way i an 'bound' this object to a table?

I also want to achieve this with an Excel OLE object, where i want to know if its possible to link individual cells to individual fields?!?

Thanks in advance, to all who reply,
Nicky.

You can bind ole objects to a field with a data type of OLE Object. But I wouldn't if I were you.

A much better practice is to store the path to a file in a text field.