multiple record entry

Hi All,

I am coding in VBA and use Microsoft Access as the front end.
My question is : I have a table(tblStudent) which has two fields Student Name and Gender.

I want to add multiple records in this table through a form at a button click....(Say I want to add least 5 students at a time)
So, I have 5 textboxes for student name, 5 textboxes for Gender and an Add button.
How do I so this programmatically?

Any help will be appreciated.
Thanks.

Hello Cus129,

Just wonder you try to import a list of student into your database or something? Assume student name textbox is txtName1 and Gender textbox is txtGender1 for the first student record. You can try to do the rest.

'----------------------
Private Sub cmdAdd_Click()
DoCmd.RunSQL "INSERT INTO tblStudent (Student_Name, Gender) VALUES ('" & txtName1 & "', '" & txtGender1 & "');"
End Sub
'----------------------