list box default

M

MattT

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
 
G

gekko97

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.
 
Top