Copy data from one field in a table to a field in another table.

[How1]

Hi,

Can someone advise how to copy data from one field in a table to a field in
another table on entry of data. I just need the code to enter against 'on
enter' in the properties box.

Thanks in advance.

 

[Jeff Boyce]

It is rare in a well-normalized relational database to need to replicate
data from one field in one table to a field in another table. You've asked
a "how do I" question.

If you'll provide a bit more information about "what I want to be able to
do", the newsgroup readers may be able to offer an approach that solves your
need without resorting to making multiple duplicate copies of data (for one
thing, you have to keep the copies synchronized).

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/