تفضل
رسالة بثلاث احتمالات
Dim rs As DAO.Recordset
Dim rst As DAO.Recordset
Dim i, ii As Integer
Dim r As Boolean
Dim rr As Boolean
Set rs = CurrentDb.OpenRecordset("data")
Set rst = CurrentDb.OpenRecordset("out")
rs.MoveLast
rs.MoveFirst
For i = 1 To rs.RecordCount
r = Nz(DLookup("crn", "data", "name1 ='" & Me.txtsearch & "'"), 0)
Next i
rst.MoveLast
rst.MoveFirst
For ii = 1 To rst.RecordCount
rr = Nz(DLookup("crn", "out", "name1 ='" & Me.txtsearch & "'"), 0)
Next ii
If r = True And rr = True Then
MsgBox "العميل موجود ضمن الحاليين والسابقين"
ElseIf r = True And rr = False Then
MsgBox "العميل موجود ضمن الحاليين فقط"
ElseIf r = False And rr = True Then
MsgBox "العميل موجود ضمن السابقين فقط"
End If
Set rs = Nothing
Set rst = Nothing
البحث في جدولين.mdb