Hi Forum,
I am trying to find a way to rewrite my code in the event that one of my record gets deleted, can the next New Record I create replace that CPCNumber... For example: I have records of CPCNumbering 1-5; I delete CPCNumber 4; the next new record will replace CPCNumber 4.
CPC Numbers are my sequential numbering system for each record created. My code writes as follows:
If Me.NewRecord = True Then
Dim CPCNumber As String
Me.CPCNumber = Nz(DMax("[CPCNumber]", "tblConcretePour"), 0) + 1
End If