Regardless of what you call custom button, it will run whatever code is behind it.
Record is committed to table when form (or table/query) closes, move to another record, or run code.
So if you want the form to close with the Save record button, include code to do that.