Copy forward information onto a new record form

[MaleNurse325]

Good day,
So, I have a form with several fields that I need to carry forward to the next new record, These feilds will only be updated infrequently.

I am trying a Before Update code that looks like this:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Manufacturer.DefaultValue= """"& Me.Model_Number.Value &""""& Me.Serial_Number.Value &""""& Me.Installed.Value &""""&Me.Input&""""& Me.Fan_Type.Value&""""Me.Anemometer_Type &""""& Me.Anemometer_Serial_Number
DoCmd.GoToRecord , , acNewRec

What have I done wrong?

 

[arnelgp]

only in the first and last do you double the delimiter:

Me.Manufacturer.DefaultValue= """" & Me.Model_Number.Value & Me.Serial_Number.Value & Me.Installed.Value &Me.Input & Me.Fan_Type.Value & Me.Anemometer_Type & Me.Anemometer_Serial_Number & """"