I have a little problem with my query, which looks like this:
WHERE (((EPATech.Abteilung)=Forms!AbtAusw!Abteilung1)) And IIf(Forms!AbtAusw!gummi="alle","","(((EPATech.Stat us)=Forms!AbtAusw!gummi))");
As you can see, if gummi ( a combobox ) has the entry "alle", I don't need the additional condition "and (((EPATech.Status)=Forms!AbtAusw!gummi))".
My solution was to use the IIF command, but somehow, it never branches into the (((EPATech.Status)=Forms!AbtAusw!gummi)) part, so I allways get every item in the table, even when gummi is not "alle".
Can anybody help me out? I don't really have an idea of what to do.