Code:
Private Sub Form_Load()
Dim assID As Long
assID = DMax("CLng(Right([LSI_Case_Number],3))", "Master_Log")
Me.LSI_Case_Number = Month(Date) & Format(Year(Date), "yy") & "-" & Format(assID + 1, "000")
End Sub
The LSI_Case_Number is text variable, do i need to change it. Master_Log is the name of the table. Me.LSI_Case_Num ber is the variable but in a form.
Any help?