list box default

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

Guest

I have about 7 list boxes in a form to represent as the selection criteria to
query my database. What should I do so that when there is nothing
chosen/highlighted in a particular listbox all those values in the listbox
are selected.

Please help. Thanks
 
You can go to your query that the form is based on, and update the
criteria from current [Forms]![SpecificForm]![listBox] to
[Forms]![SpecificForm]![listBox ] Or [Forms]![SpecificForm]![listBox]
Is Null ** All in same line**

This will capture all the items in the specific field if a value is
selected from the list box or is the value is null from the list box.
 
Back
Top