List boxes and ADO object Filter

[thread]

Hi all,
i need to enter criteria based on several list boxes
it works only if i have just one criteria in every list box
otherwise it will raise the error 'run time 3001'
is it posible to overcome this problem?

 

[pietlinden]

Hi all,
i need to enter criteria based on several list boxes
it works only if i have just one criteria in every list box
otherwise it will raise the error 'run time 3001'
is it posible to overcome this problem?

you can't use multi-select listboxes in queries directly. Read this
article:
http://www.mvps.org/access/forms/frm0007.htm

 

[thread]

you can't use multi-select listboxes in queries directly. Read this
article:http://www.mvps.org/access/forms/frm0007.htm

my problem is not with the form and the way i''m passing the
information(i know that it can only be used with combo box) my issue
is how do i pass all the criteria in the correct way to the ADO
filter,the way i'm building the criteria to the form is not working
for the ADO
i can use
with control
..........
end control
to build criteria for the form but i cannot pass this criteria to the
ADO
i found some way that it is quite clumsy by finding the bigesnt number
of items that have been selected and that way to build for loop that
will pass on the items but i want to know if there is simple way to do
it becaouse its not aligned as i said with the form filter and taking
extra resource to track the changes