txt_siparis_no = Format(Date, "yyyy") & "-" & Nz(DMax("clng(mid([siparis_no],6))", "accessTR", "left([siparis_no],4)=" & Format(Date, "yyyy")), 0) + 1
aşağıdaki kodu deneyebilirmisiniz?
husem, proud to be a member of AccessTr.neT since 08-03-2009.