ارجو المساعده

Suppose you have a form(employeeF) includes fields

Field 1 : employee

Field 2 : date

Ales you created a 2 combo boxes for search

Combobox 1 : combemployee

Combobox 2 : combdate

Create a button

Button : cmdSearch

Put the following code event in the button which is :

Private cmdSearch_click()

On error resume next

If isnull (me.combemployee.value) then

Docmd.applyfilter, "employee = Forms![employeeF]![combemployee]"

Elseif isnull (me.combdate.value) then

Docmd.applyfilter, "date = Forms![employeeF]![combdate]"

End if

أخي العزيز، إذا أردت الحل الشافي نرجو منك إرسال مرفق عن مشروعك، وشكرا