Getting information from one table and saving info into another

[David Ball]

Hi,

I want a form that takes values from a table to display titles and general information for each record but with an area where people can leave comments and notes that are saved. I update the table very regularly by deleting everything in the table and pasting in fresh data from Excel so I am thinking the comments and notes will need to be added to a different table.
Apart from these comments I would need a unique identifier record in the new table to tie the info together. I have a field, ProjCode, that can do this.
How can I have ProjCode being provided by one table and then also appear in another and then have the new comments also saved into this other table?
I’m very confused about Record Source and Control Source and don’t really know how I am going to do this.
Any suggestions, please?

Thanks very much
Dave

 

[Ranman256]

queries.
in the macro, you should add the excel data using 3 queries;
1 to delete the regular table
1 to add to the regular table,
1 to add to the perm. archive table.

if you modify the regular table with comments, use an update query to add them to the archive table before the delete query.