List Box

[x]

try to test if the conditions/selections you're using
on the list box was satisfied (if not that means, no
records gathered right?)

its working on single condition you said....

-----Original Message-----
Hey,

I have a list box and a query that is connected

to the list box like this...[Forms]![Interface]![List169]

When I run the query the results come up perfectly. But

when I want to select multiple selections in the list box
and run the query, it comes up with a blank screen after
setting MultiSelect to Simple. Any ideas??

 

[Guest]

yes all of the choices in my list box match the conditions of the query. i tested each one individually and they all work individually when Multi Select is off. is there something that needs to be written in the criteria to let this happen other than [Forms]![Interface]![List169

----- x wrote: ----

try to test if the conditions/selections you're usin
on the list box was satisfied (if not that means, no
records gathered right?

its working on single condition you said...

-----Original Message----
Hey

to the list box like this...[Forms]![Interface]![List169

When I run the query the results come up perfectly. But

when I want to select multiple selections in the list box
and run the query, it comes up with a blank screen after
setting MultiSelect to Simple. Any ideas??

 

[x]

sample
list items

1
2
3
4

i selected 1 and 4

so the query should be...where x=1 or x=4

got the idea?

-----Original Message-----
yes all of the choices in my list box match the

conditions of the query. i tested each one individually
and they all work individually when Multi Select is off.
is there something that needs to be written in the
criteria to let this happen other than [Forms]![Interface]!
[List169]

----- x wrote: -----

try to test if the conditions/selections you're using
on the list box was satisfied (if not that means, no
records gathered right?)

its working on single condition you said....

-----Original Message-----
Hey,

connected
to the list box like this...[Forms]![Interface]! [List169]

When I run the query the results come up

perfectly. But
when I want to select multiple selections in the list box
and run the query, it comes up with a blank screen after
setting MultiSelect to Simple. Any ideas??.

 

[Doug Munich]

I don't know how multiple selections are stored in a listbox, but is it
possible that it is ANDing them, i.e. querying records that have all the
selected values rather than any?

Doug

sample
list items

1
2
3
4

i selected 1 and 4

so the query should be...where x=1 or x=4

got the idea?

-----Original Message-----
yes all of the choices in my list box match the

conditions of the query. i tested each one individually
and they all work individually when Multi Select is off.
is there something that needs to be written in the
criteria to let this happen other than [Forms]![Interface]!
[List169]

----- x wrote: -----

try to test if the conditions/selections you're using
on the list box was satisfied (if not that means, no
records gathered right?)

its working on single condition you said....

-----Original Message-----
Hey,
I have a list box and a query that is

connected
to the list box like this...[Forms]![Interface]! [List169]

When I run the query the results come up

perfectly. But
when I want to select multiple selections in the list box
and run the query, it comes up with a blank screen after
setting MultiSelect to Simple. Any ideas??

.

.