If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Copy Row Contents from one form to another

Hi Team,

I am relatively new to Access. Need help in copying Rows from one form to another. For Ex : I have form named "Table 1" and in that form i have a Row with Heading "Name". I want the contents of the names to be appear in another form "Table2". I know this can be done using Query . However i need to add additional fields to Table 2 wherein in query you cannot do it.

Please note i am new to this software thingy .. please dont ask me write scripts as i dont know what it is ... If anybody could provide with me with a script that would be great.

Let me be more clear i have a Fom(Table 1) with the folowing fields ... NAME, LOCATION, COUNTRY,LANGUAGE,INTEREST .. Now I want a copy NAME AND COUNTRY automatically in another form (Table2) with another fields .

My new form (table2) should have NAME and Country from Table 1 and addtional fields that i am keep adding ...

Please note the form(table 1) is directly linked to my mail box and it gets updated everytime a mail comes ... i also want my table 2 to be updated automatically when table 1 is updated.