When there is any new record, how can I export it to another table?

[1308057]

Hi,

I'm new to access vba.

I have 2 table, A & B. When I enter new record in table A, i want the record to be copied to that of table B. They are operating seperatly.

How can I do so? Thanks a lot for any advices

 

[georgedwilkinson]

Why so many tables?

 

[1308057]

Why so many tables?

Hi,

I need another table because there are 2 operation in the database,
is the technique something like "Recordset"?

 

[khawar]

Avoid duplicating your data it is always difficult to maintain
Can you tell what are you trying to do

 

[georgedwilkinson]

It's really difficult to understand the question, and how to answer it, without understanding what you're doing and why you're doing it. Why do you need to insert data into 2 tables at the same time? The only time in 25 years I've had to do that is for some implementations of polymorphism. So why are you doing it?

 

[1308057]

It's really difficult to understand the question, and how to answer it, without understanding what you're doing and why you're doing it. Why do you need to insert data into 2 tables at the same time? The only time in 25 years I've had to do that is for some implementations of polymorphism. So why are you doing it?

Thanks all for kind reply,

I applogize if my presentation was not clear.

***********************************************

One main function of my database is to keep record of Client Information.

It is planned to have 2 tables, one is for original record history (i.e. to record the staff's original data entry) , the other table is for updating (i.e. if staff need to update record in the future).

There is a form linked to table 1, by clicking a Save button on that form, record will be saved at table 1.

What I want to achieve is that, the record saved at the form can also update table 2.

Can I write some VBA code on the "save" button to do so? Or i need to use something like "Append query"??

heartfully thanks for any advice!

 

[georgedwilkinson]

I guess the server went down while I was posting my answer.

Short answer is: don't do this. Put the data all in the same table. No need for one line of VB code.

If you're going to do audit tables, that's a different thing, but not what you said you're doing.

 

[georgedwilkinson]

I've gotta go and am going to drop out of this thread...sorry. Perhaps one of the other fine posters here can help.