جرب المرفق ... ربما يكون هو طلبك استخدمنا طبعا هذا الكود في حدث بعد التحديث
If IsNull(Me.txtSS) Or Me.txtSS = "" Then
MsgBox "Enter Passcode", vbCritical, "Movement System"
Exit Sub
Else
If DCount("sta", "barna", "[txtPassword] = '" & Me.txtSS & "' And [sta]= '" & "Open" & "'") > 0 Then
MsgBox "لديك طلب مفتو ويجب اغلاقة", vbCritical, "عملية خاطئة"
Exit Sub
Else
Me.txtFullNameEN = DLookup("[FullNameEN]", "qryUsers", "[txtPassword]='" & Me.txtSS & "'")
Me.txtEmployeeNumber = DLookup("[txtEmployeeNumber]", "qryUsers", "[txtPassword]='" & Me.txtSS & "'")
Me.txtEmpID = DLookup("[txtIntPersonID]", "qryUsers", "[txtPassword]='" & Me.txtSS & "'")
Me.txtSS = ""
Me.cmbVehicleNameEN.Enabled = True
End If
End If
مع اضافة استعلام ...
Database1.accdb