you want to add a record to table tblXYZ which contains fields fldThis, fldThat, fldOther, fldLast.
private sub TheNameOfYourButton_Click()
dim dabs as dao.database
dim recs as dao.recordset
set recs =dabs.openrecordset("tblXYZ")
'you did it! one record added to tblXYZ !!
'you can now add data in this new record
recs!fldThis = "This string will be stored in fldThis
'or e.g. variables that are in scope
recs!fldThat = myVariable
'or e.g. from boxes on a form
recs!fldOther = Forms!ThisForm!ThatSubform.whateverBox.value
'or e.g. the bound value of a combo
recs!fldLast = mycombo.value
'now you need to do the equivalent of clicking the pencil in table-view