Query Criteria from CMBbox: showing ALL data when CMB is empty

[JCamara]

Hello!

My situation is: i have a form based on a query, and the query's criteria are based on combo boxes inside de form.
fair enough, i can make it filter the results based on what i input on the CMBbox.


problem 1: when that CMBbox is empty (when you launch the form), there's no results, all query's (and therefore form's) lines get blank. When you fill the box, it shows filtered results.
I'd like it to show ALL data when there's nothing sellected. when filling one of the boxes, it'd filter the whole thing.

problem2: if i put more than one combo-box they only work together. i want each one to act as a separate filter, but it only works when all boxes are filled.
I think that solving problem 1 this problem is also solved.


here are my approaches:
-trying to use "*" somewhere on query's criteria (e.g.: like "*[forms]![myform]![myCMB]*" )
-trying to use boolean logic on query's criteria (e.g.: iif([forms]![myform]![myCMB]="";"*";[forms]![myform]![myCMB])

none of them seemed to work...

thanks in advance!

 

[Leandroarb]

Hi!

Try: Like & "*" forms!myform!myCMB & "*"

 

[JCamara]

thanks! Needed a little tweek; it worked as:

Like "*" & forms!myform!myCMB & "*"

 

[Leandroarb]

Worked how do you need it?