HELP in vb6 connectiion in datagrid(table1) to another table(table2) in access?

i have created 2 tables name table1 and table2 with the same fieldnames in subjectnumber(sub-0001), subjectname(english1) but in my table2 i added studentnumber(s-0001) and studentname(paul)

im using dataenvironment in connecting my (table1) ms access 2007 database in a datagrid but my problem is how to save and add all information bind(table1) in datagrid into another database table2 in my ms access, i want to connect what is inside my datagrid (table1) and add to (table2)

i mean using dataenvironment i bind table1 to a datagrid1(table1) so i want all information bind in datagrid1 to add and save into table2 database in just 1 commandbutton click in vb6.

I have 2 forms in vb6, form1 only the subjectsnum & name connect into a datagrid. however, in form2 it is the same but i added the studentnum and name textboxes but the subjects likewise are in a datagrid connect in dataenvironment. i want to save all information in the datagrid as well as the student number/name in the textbixes in just 1 command button, click SAVE, in vb6..

hope you understand my problem and FOR FREE...

thanks in advance....GOD bless...


Below i attach my form2 problem. saving all information in a datagrid in just a single commandbutton click and it will automatically save all inside the datagrid.
and also the studentnum and name will also save.

Attached Thumbnails

 

re: HELP in vb6 connectiion in datagrid(table1) to another table(table2) in access?

Greetings, psyvanz!

I would add all of the code you have thus far; most developers are usually just passing through. You'll get better, sound results that way:-)

Good luck with the project!

Dököll