Hello,
I am trying to create a query based on 5 inter-dependent combo-boxes. At the criteria of each field than i want to "filter" i put something like [Forms]![FormName]![cbo1].
My main problem is that these combo boxes are all set to "not visible" (except the first one) at the begging and based on the selection of each upstream combo, the next one become visible. Eg: I select a section, then the lines in that section become visible and i select a line, then the equipment referring that line becomes visible and so on.
However, not every time i get to choose data from all 5 combos and probably the last 2 will never show up, since they have no data to display.
I believe that access doesn't know how to query non-visible data from combo-boxes... I also tried something like "Like IIf([forms]![FormName]![cbo1]="","*",[forms]![FormName]![cbo1])
If i put a criteria for a query only for the visible fields, it works...
Any ideas how can i solve this issue?
I am trying to create a query based on 5 inter-dependent combo-boxes. At the criteria of each field than i want to "filter" i put something like [Forms]![FormName]![cbo1].
My main problem is that these combo boxes are all set to "not visible" (except the first one) at the begging and based on the selection of each upstream combo, the next one become visible. Eg: I select a section, then the lines in that section become visible and i select a line, then the equipment referring that line becomes visible and so on.
However, not every time i get to choose data from all 5 combos and probably the last 2 will never show up, since they have no data to display.
I believe that access doesn't know how to query non-visible data from combo-boxes... I also tried something like "Like IIf([forms]![FormName]![cbo1]="","*",[forms]![FormName]![cbo1])
If i put a criteria for a query only for the visible fields, it works...
Any ideas how can i solve this issue?