اشكرك اخ ابو نادر
واسف لاني لم انتبه الى الوحدات النمطية ولكن المشكلة الان في اغلاق
RstSrchforDublc.Close في جملة ELSE الاخيرة
وهذا هو الكود كما كتبته
اذا كان بالامكان مراجعته ولك جزيل الشكر
Option Compare Database
Option Explicit
Dim CnnLocal As New ADODB.Connection
Dim RstSrchforDublc As New ADODB.Recordset[/align]Const ConErrNoValue = "3021"
Const ConErrInvalidUseOfNull = "94"
Dim StrNameEng As String
Dim IntInvoice_No As Integer
Private Sub Invoice_No_Exit(Cancel As Integer)
On Error GoTo Err_Form_Invoice_No
Set CnnLocal = CurrentProject.Connection
RstSrchforDublc.Open "TblDataEmployee", CnnLocal, adOpenStatic
RstSrchforDublc.Find "Invoice_No LIKE '" & Invoice_No & "'"
'StrNameEng = RstSrchforDublc!Name
IntInvoice_No = RstSrchforDublc!Invoice_No
RstSrchforDublc.Close
If IntInvoice_No = Invoice_No Then
DisplayMessageCritical "There's Duplicate Employee No. " & IntInvoice_No & " For" & vbCrLf & "" & vbCrLf & _
"Employee :" & StrNameEng & "" & vbCrLf & "" & vbCrLf & _
"In Administrative Personal DataBase.", "Duplicate Employee No."
End If
Exit_form_Invoice_No:
Exit Sub
Err_Form_Invoice_No:
If Err.Number = ConErrInvalidUseOfNull Then
Resume Next
ElseIf Err.Number = ConErrNoValue Then
RstSrchforDublc.Close
Else
RstSrchforDublc.Close
DisplayMessageCritical Err.Description, "Error Message"
End If
Resume Exit_form_Invoice_No
End Sub[/align]