One method of inserting a new record is using the INSERT INTO with SQL:

INSERT INTO tblCustomer (FirstName, LastName, Age) VALUES ("Joe", "Smith", "31")

Or you can do this:

INSERT INTO tblCustomer SELECT FirstName, LastName, Age FROM tblCustomer2

Or, you can use the ADDNEW method using the RecordSet Object:

RS.AddNew
RS("FirstName") = Request("varFirstName")
RS("LastName") = Request("varLastName")
RS("Age") = Request("varAge")
RS.Update