Hi,
I'm trying to use 6 combo boxes to filter the records on an
underlying subform. I want the results to be determined by cboBox1
AND cboBox2, etc.
The problem that I encounter is how to still query the subform when
there are multiple null values. I don't want the user to have to
fill out all of the boxes, just the ones that are specific to their
search. When I have done this in the past it has been easy because I
was only using 2-3 combo boxes and could say if cbobox1 is null and
cbobox2 is null then cbobox3 is the criteria, etc. But with so many
boxes the variations/possibilities are too many. There must be an
easier way.
Any help would really be appreciated. Thanks.
Dan
I'm trying to use 6 combo boxes to filter the records on an
underlying subform. I want the results to be determined by cboBox1
AND cboBox2, etc.
The problem that I encounter is how to still query the subform when
there are multiple null values. I don't want the user to have to
fill out all of the boxes, just the ones that are specific to their
search. When I have done this in the past it has been easy because I
was only using 2-3 combo boxes and could say if cbobox1 is null and
cbobox2 is null then cbobox3 is the criteria, etc. But with so many
boxes the variations/possibilities are too many. There must be an
easier way.
Any help would really be appreciated. Thanks.
Dan
