I have a form, that contains multiple fields for a record. I want to enable the user via a button to copy all the data from the existing record and create a new one however I want one field to be automatically created as part of the insert.
The field that uniquely identifies each record is FileNo
The field is created as part of the before insert of the form is :
Private Sub Form_BeforeInsert(Cancel As Integer)
If Me.NewRecord Then
Me.FileNo = Year(Date) & "1" & Format(Me.InvoiceID, "00000")