Filter a Listbox with multi combo boxes and a list box

[jeannier1975]

Iwould like to create a form in which a listbox displaying records from Projects is filtered based on the selection of a comboboxs Dept and Tech , Date From and DateTO combo boxes containing the Project Data

in other words, i want to select "Dept " (value 1) in the combobox, "Tech" (value 2) in the 2nd combo box , "DateFrom" ( value 3) 3rd combobox, and "DateTo" (value 4) and have only the records from Tech that have value 1 in their ProjectNo field displayed in the listbox?

Here the link to my database
http://s000.tinyupload.com/?file_id=...35865929230614

[twinnyfo]

Jeannier1975,

Welcome to Bytes!

Please know that folks on this forum are not apt to download your database, simply because you provide it. This is for obvious security reasons.

Second, we are also not apt to create the solution for you, simply because you ask. We would be glad to take a look at your wrk thus far and provide guidance toward a solution. But, we will not do the work for you.

Please re-examine your exact requirements, create an initial solution yourself, and if there are challenges you face, then we can help troubleshoot.

Thanks!