بسم الله الرحمن الرحيم
استخدم هذا الكود
Dim T As Long, NumID As Long
If RecordCount = 0 Then txtID = 1
If RecordCount > 0 Then
With Recordset.Clone
.MoveFirst
For T = 1 To .RecordCount
NumID = NumID + 1
If !id <> NumID Then
txtID.Text = NumID
Exit Sub
End If
.MoveNext
Next
txtID = NumID + 1
End With
End If
مع تحياتى
mzaki