Using form to add new record to multiple tables

[mophead]

Hi all,



I'm new to the forum as well as somewhat of a beginner in Microsoft Access. I am working currently on campus helping a program fix its Access database. Pretty much, they have three tables all related by an email. Each table has certain information about the person. The form has all the fields of each table. Currently, I can use the form to update current information about a person, and this will change that field in the table. There is also a new button on the form that creates a new record. However, this new record is only added to the current form datasheet and does not add the new record to each of the three tables. I'm wondering if there is a simple way to do this? I'm not that proficient in VBA coding but I do understand it, so if that is a solution please let me know. Thanks in advance for all your help!

[burrina]

Why the duplicate data? Of course you could always do a after update event and say something like Me.MyField = DestinationField