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 ...
Letting Users Update Information