yes, (less vba, more querys/macros)
have the button execute a query, docmd.openquery "quUpdFields"
your query will use the form values and post in the table...
similar to
quUpdFields:
update table ([field1], [field2]) values ('" & forms!frmMain!txtBox1 & "','" & forms!frmMain!txtBox2 & "')"