Filter a Subform with 4 combo box

[Tlegendz8]

Good Afternoon,

I have acess 2010 and i want filter my subform with 4 combo box value.
My subform must show Nome and Descrição from T_doença. The combo box show the Nome and sintoma_Id from T_sintoma.
There is a table that relates doença_Id and sintoma_id.
What i want is to find the doença_Id, and therefore Nome and descrição for the subform, that have the sintoma_Id from combobox1, and the combobox2, and so on.
The form is F_Doença and the subform SF_Pesquisa.



It is a program that filters illness that have the 4 symptons in the combobox's, doesnt show the rest (for example an ilness that has 3 of the 4 symptoms won't appear)

File: https://feupload.fe.up.pt/get/QCFOH0UKbwBEscT
I cant upload it by the forum becaus it has 4 mb
Any suggestions?

Thank you

[June7]

Next time, run Compact & Repair (reduced to 1.2MB) then zip the file. 2MB zip attachment allowed.

Two ways to apply multiple parameters:

1. dynamic parameterized query, review http://www.datapigtechnologies.com/f...tomfilter.html

2. VBA code constructs filter string, review http://www.allenbrowne.com/ser-62code.html

F_Doenca does not have a subform on it.

SF_Pesquisa is on F_Pesquisa.

QSF_Pesquisa is a GROUP BY query. This is not editable query. If you want to do data entry/edit on the subform, cannot use GROUP BY query.