I have table in Access 2007 called Students whose fields are
Student ID Number
Student Name Text
I created a form based on this table called Student Form. on this form I have a command Button called Save. Basically What I am looking is onclick of this Save button I want to grab the Student ID from Student table and Insert into Student ID of Billing table, Student ID of Grades Table, Student ID of Financial Aid table.
Is this possible, I know I can insert into one table by using the code below
Private Sub cmdSave_Click()
On Error GoTo Err_cmdSave_Click
Dim strSql As String
strSql = "INSERT INTO Billing([Student ID]) SELECT Students.[Student ID] from Students;"
Can Insert into multiple tables using the same concept.
Thanks and appreciate it