Private Sub NXK_NHAP_Change()
Dim Tmp As String, MyAdd As String, lNum As String
Dim Rng As Range, sRng As Range
Dim Rws As Long, Num As Long
Tmp = Me!NXK_NHAP.Value & CStr(Year(Date) Mod 100) & Right("0" & CStr(Month(Date)), 2)
lNum = "0000"
' Tmp = NXK_NHAP.Value & "#" & Right(Year(Date), 2) & Format(Month(Date), "00") '
With Sheets("Chi_Tiet_nhap")
Rws = .Range("B" & Rows.Count).End(xlUp).Row
Set Rng = .[B5].Resize(Rws)
Set sRng = Rng.Find(Tmp, , xlFormulas, xlPart)
If Not sRng Is Nothing Then
MyAdd = sRng.Address
Do
If Right(sRng.Value, 4) > lNum Then
lNum = Right(sRng.Value, 4)
End If
Set sRng = Rng.FindNext(sRng)
Loop While Not sRng Is Nothing And sRng.Address <> MyAdd
lNum = Right("000" & CStr(CLng(lNum) + 1), 4)
Me!SO_PHIEU_NHAP.Caption = lNum
'Chu Bài Dang Viêt Tiêp Vài Câu Lênh Thêm Vào ?ây: '
Else
Me!SO_PHIEU_NHAP.Caption = Tmp & "0001" Mã Đầu Tháng '
End If
End With
End Sub