Access 2010 web database, how do I save records to a table?

[ninjamustang]

Hello,

I'm using Access 2010 and now trying to save a selected record to another table which I have no clue where to find the "Code Builder" to put my code on after spending hours and hours, I managed to create a form, but couldn't figure out where to save this data.

All I need is to put this line
"INSERT INTO ResultTable (StudentID, CourseID, PaidID, Comments) VALUES (" & cboStudentSelect & ", " & cboCourseSelect & ", " & cboPaymentSelect & ", " & txtComments & ") WHERE StudentID = cboStudentSelect

Perhaps, the new Access 2010 doesn't use this or something new that I couldn't it.

Attached is the file.

Thank you for your help in advance.

 

[Mihail]

In order to gain more help, convert the DB in Access 2003 format and upload again.

... and now trying to save a selected record to another table...

This will broke the concept of Normalization:
Database Normalization and Table Structures - Microsoft Access / VBA

 

[ninjamustang]

I guess I'm out of luck now since I upgraded my Microsoft Access 2007 to 2010. Now there is no option to save anything but 2010.

I could make a new one using a regular database and not web database, but I'd really like to have this web database to work since you can put publish it to website.