Updating data entered in one table automatically into another

[oggsta]

After I enter details in a form called [Main] field sitename, i would like this informtation to be automatically be updated in a form called [sheet1] feild name sitename.

The information will be hidden but it will be used to generate a query and mailmerge to word.

I could use the following to achive this however it does not work when i mailmerge,
=[Forms]![Main]![Sitename];

Preferbally I would like to use the after update event in teh [Main]![Sitename] feild to automattically enter the same details in [Sheet1]![Sitename],

Any help in relation top teh code required would be appreciated

 

[jrbarnett]

If you have a form bound to a table, with controls on the form bound to fields in that table, when you save the data on the form, it will get recorded in the table. Likewise, any updates and deletes from the form will get reflected in the table.
All you need to do is make sure the form Main is bound to Sheet1.

John