Hi All,
i’ve a problem on the sequencing number. Hope your can help me out of this.
What i wish to get isCode:Private Sub Frame97_AfterUpdate() Dim LValue As String LValue = Format(Date, “yymm”) Me.txtscar = Nz(DMax(“SCAR”, ”F1NCtbl”, “SCAR = “”IQA ” & [LValue]), 0) + 1 End Sub
IQA 2002XX (xx – running number)
In my table, i have a field for SCAR only. Not sure why i cant get the number. Can you help on this?
Thank You,
Regards,
tonyshieh