Copying fields from one table to another automatically

[Hediru]

I maintain a massive MS Access Database for the project I'm working on. Here
is the situation. I have a table that lists contact information for people
who work on the project (including email addresses). I also have a table that
keeps track of the same people and what email distribution lists they are on.
Now what I'd like to do is set up a macro so that whenever the contacts table
gets a new record, it automatically copies the name and email fields to the
distribution list table. How do I do that?

 

[Jeanette Cunningham]

Hediru,
this is not exactly what you are asking but . . ..
Wouldn't it be easier to get the names and email addresses by just running a
query on the contacts table when you need them?

If you want to do it the other way, how do you add new records to the
contacts table?
Is it only by one particular form?
Are you sure it will never be done by an update query or an import?


Jeanette Cunningham -- Melbourne Victoria Australia