Multiple Listboxes and Control Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with 4 listboxes and 1 set of text boxes for a Date Range that
i want to use as selection criteria to pull up a report. I have been able to
pull the report with one list box and the date range but it will not work
with more than one listbox. I am using Where condition.
 
It should work provided that you correctly build your where condition, which
would probably be something like

"fielda = '" & listbox1.value & "' and fieldb = '" & listbox2.value & "' and
fieldc = '" & listbox3.value & "' and fieldd = '" & listbox4.value & "' and
datee >= #" & date_text_box_1.value & "# and datef <= #" &
date_text_box_2.value & "#"

Note that the above assumes all the fields are being searched with text
values. For number fields, remove the single quotes.
 
Back
Top