I have a a field called "FileNo" this number is generated automatically via
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.FileNo = Year(Date) & "1" & Format(Me.InvoiceID, "00000")
The problem is that I have a record that was created last year as example
FileNo = 201312345677
when a user opens the record via the form and changes one of the field values the FileNo is being recreated and saved as :
FileNo = 201412345677
ONce the FileNo is originally created I do not want it changed no matter what other changes to the record are being made subsequent to the intial creation of the FileNo.