Help building a command button to save the record, but keep some data for next record

[Perimeter]

Hello,



I have a form with a dozen fields, and a save button "Save Button" that saves the record and clears the form - works awesome.
I would like another save button "Enter Next" that saves the record but keeps the current data for fields A, B, and C and clears the rest of the form.

As always thank you all for your time!

[ranman256]

sub btnSave2_click()
dim vVal1, vVal2, vVal3

'hold your special data
vVal1 = txtBox1
vVal2 = txtBox2
vVal3 = txtBox3

'save data
DoCmd.RunCommand (acCmdSaveRecord)

'clear the fields
==== PUT YOUR CLEAR FIELDS CODE HERE

'reload special data
txtBox1 = vVal1
txtBox2 = vVal2
txtBox3 = vVal3
end sub

[Perimeter]

That worked... beautifully!