Public Function MaxCID() As Long
MaxCID = Nz(DMax("CustomerID", "CUSTOMERDETAILS"), 0) + 1
End Function
this mod returns the next available integer CustomerID
is there a way to modify this existing mod to SPLIT & INCREMENT a STRING Id, P100, to return P101 ??
MaxCID = Nz(DMax("CustomerID", "CUSTOMERDETAILS"), 0) + 1
End Function
this mod returns the next available integer CustomerID
is there a way to modify this existing mod to SPLIT & INCREMENT a STRING Id, P100, to return P101 ??