Unanswered: Copy Row Contents from one form to another
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.