list box default

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query base on list box 1
multiple listboxes on one form 4
List Box won't refresh 2
ADDING values from one listbox to another on same form 1
List Box Focus 4
Access Cannot select items in listbox 1
Form query criteria doesn't recognize function 1
Listbox Help (remove selected item) 1

Top