One form - want to populate two tables at once

[mariaw]

Hi

I have a form created from Table1

I have another Table2 - which is identical to Table2

I want Table2 to automatically update with the information put on the form (which currently only populates Table1) without asking the user whether they want to do this. And when I say update, if a user adds a new record to the form, I want that new record to be put on Table1 and Table 2.

I am using Access 97....

Help ))

Thanks

Maria

 

[MStef]

Hello Maira!

You don't need the same data in two tables.
If you wont it, try to do it with APPEND QUERY, in
Sub Form_AfterUpdate.

 

[MStef]

Or in Sub Form_AfterInsert.

 

[mariaw]

One form - two tables : THANK YOU!!!

Hi MStef

Thank you so much - sometimes I just need someone to point me in the right direction!!!

good luck against Brazil tonight - will be watching!

Take Care

Maria