Choose table to copy data into

[Agism]

I have been reading threads about archiving and cloning but I am still lost.

What I have are multiple tables, each with questions for a specific application. I need to find a way that users can copy a question from one table to another.

Previously users would copy and paste directly in the tables, but they have asked that everything be tracked. So, I need to either find code that will track every paste in a table or I need to know how to do this through a form.

Please help.

 

[MikeAngelastro]

Would you please provide a little more detail so I can give you a focussed answer.

 

[Agism]

More info...

There are 9 tables with basically, the same fields. Each table holds checklist questions for a specific application the user will be QAing.

I also have an Audit Table that records all the changes made to certain fields in specific forms. I found this information on a thread here. The code that is added to the BeforeUpdate of each field is: "WriteAuditUpdate txtTableName, Me.QuestionID, "Field Name", Me.Field.OldValue, Me.Field.Value"

My first problem was that the users made edits directly in each table. I could not figure out how to use the code I had in a table so I created a form that appeared in datasheet view and had the code behind it.

Now I have been told that since some of the applications are very similar, the users will copy questions/records from one application's table and paste them into the similar application's table. They would like to have this pasted recorded in the audit table as well.

What I need to know is how to track the pasting of records into a table or form.

I would really appreciate the help. Let me know if you need more information.

Thanks!

 

[Agism]

Thoughts?

Any idea for me?

Please.