In ADO, you can use either Addnew or issue an Sql Insert statement to add a new record to a db.
Maybe this article can help. It's almost about what you said: add a record to a db, using a button, except that the code to execute the insert is not used in a function or sub routine, but rather as an inline code block. At least you can pick up from there . . . better than none ... :D
Letting Users Update Information (http://aspalliance.com/aspxtreme/ado/lettingusersupdateinformation.aspx?pageno=2)