listbox help

[tkaplan]

I have a form with a listbox on it. the list box contains site numbers. (lstSite)

i would like the user to select which site/s they want information for.

i have another query that includes site,date,and other data
i put in the criteria for site as being forms!main!lstSite.value but it is not showing any records, even if i did select the site. i also tried forms!main!lstSite. this did not work either.

I have a feeling i am refering to the object incorrectly.

any help would be greatly appreciated

tkaplan

 

[selenau837]

I have a report menu that I use as a filter for reports. I use combo boxes instead of list boxes and I reference them as 'me.cmbboxname.value'.

For some reason, I am thinking we used combo boxes instead of list boxes because we couldn't get them to work. I could be wrong, but the combobox works great.

If you want I can copy and paste the code we use becuause we have 6 filters that can be used at any given time for the Many reports we have.

HTH.

 

[tkaplan]

i need the user to be able to select more than one value, so combobox would not work.

thank you anyway.

I think i need to use some sort of code to have the values of the selected put into an array and then split that??

anyone have any suggestions?