How to copy OLE fields between two tables

Hi folks,

I have an Access database containing two tables. The first table
(tblSource) contains an OLE field in which Word documents are embedded.
The second table (tblDestination) is similar to the first one, as it
contains also an OLE field for Word documents. I created a form based
on the table tblDestination. From this form, I want to be able to
select a record from the table tblSource, and copy the OLE content of
that record in the current OLE field on my form i.e. in the current OLE
field of the current record of the table tblDestination.

The record to be copied would be selected using a drop list control
(showing a text field in tblSource), and the copying action would be
triggered by a button click.

Thank you very much in advance,
Marc Melillo

Just copy the field's contents directly from the source to the destination
field. Post the code you've got so far and someone will be able to help you
work through it.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"marcm" wrote in message
oups.com...
Hi folks,

I have an Access database containing two tables. The first table
(tblSource) contains an OLE field in which Word documents are embedded.
The second table (tblDestination) is similar to the first one, as it
contains also an OLE field for Word documents. I created a form based
on the table tblDestination. From this form, I want to be able to
select a record from the table tblSource, and copy the OLE content of
that record in the current OLE field on my form i.e. in the current OLE
field of the current record of the table tblDestination.

The record to be copied would be selected using a drop list control
(showing a text field in tblSource), and the copying action would be
triggered by a button click.

Thank you very much in advance,
Marc Melillo