Copying fields from one table to another automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hediru - 17 Apr 2008 21:43 GMT

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?

Reply to this Message

Jeanette Cunningham - 01 May 2008 12:48 GMT

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

>I maintain a massive MS Access Database for the project I'm working on.
>Here
[quoted text clipped - 8 lines]
> the
> distribution list table. How do I do that?

Reply to this Message