Create table that will automatically contain data from another tab

[buxton]

I want to be able to create a table that will contain data from another table
automatically when a linked data field is entered. I still need to be able
to change this data in the form if necessary. Is this possible?

 

[John Vinson]

I want to be able to create a table that will contain data from another table
automatically when a linked data field is entered. I still need to be able
to change this data in the form if necessary. Is this possible?

No; but the good news is that it is neither necessary nor desirable either.
Storing the same data redundantly in two tables is NEVER a good idea.

Simply base your form on a Query linking the two tables, or use a Form based
on one table with a Subform based on the other, using the link field as the
master/child link field of the Subform control.

If I've misunderstood the situation, please accept my apologies and post a
further explanation.

John W. Vinson/MVP