تفضل هذا التعديل اخي الكريم
اللصق الجملة في الاستعلام فقط
SELECT EMPDEV.IDED, EMPDEV.IDD, EMPDEV.DATER, EMPDEV.DATEG, EMPDEV.NOTES, EMPLOYEE.IDS, EMPLOYEE.NUMBER, EMPLOYEE.ENAME, class.CNAME, DLookUp("[BRANDS]","[MARKA]","[IDM]=" & [EMPDEV]![IDED]) AS [الشركة المصنعة], DLookUp("[MODELS]","[MARKA]","[IDM]=" & [EMPDEV]![IDED]) AS الموديل, DLookUp("[TYPE]","[MARKA]","[IDM]=" & [EMPDEV]![IDED]) AS النوع
FROM class INNER JOIN (EMPLOYEE INNER JOIN EMPDEV ON EMPLOYEE.[IDE] = EMPDEV.[IDE]) ON class.IDC = EMPLOYEE.IDC
WHERE (((EMPDEV.IDED) Like "*" & [forms]![EMPDEVMENU]![TXTFIND] & "*")) OR (((EMPDEV.IDD) Like "*" & [forms]![EMPDEVMENU]![TXTFIND] & "*")) OR (((EMPDEV.DATER) Like "*" & [forms]![EMPDEVMENU]![TXTFIND] & "*")) OR (((EMPDEV.DATEG) Like "*" & [forms]![EMPDEVMENU]![TXTFIND] & "*")) OR (((EMPDEV.NOTES) Like "*" & [forms]![EMPDEVMENU]![TXTFIND] & "*")) OR (((EMPLOYEE.IDS) Like "*" & [forms]![EMPDEVMENU]![TXTFIND] & "*")) OR (((EMPLOYEE.NUMBER) Like "*" & [forms]![EMPDEVMENU]![TXTFIND] & "*")) OR (((EMPLOYEE.ENAME) Like "*" & [forms]![EMPDEVMENU]![TXTFIND] & "*")) OR (((class.CNAME) Like "*" & [forms]![EMPDEVMENU]![TXTFIND] & "*"));
تفضل التعديل في المرفقات
PROGRAM IT (2).rar