[MsMewiththat]

I have a question for you in regards to a list box in a query. I have a form that I am using and want to give the users some options on what years they want to pull data from. So I was thinking about creating a list box or drop down box that would display the available years, when they highlighted them (morethan one at a time shift+) they would be able to append those to a holding table that you could then run a report from. Any ideas on how to handle this best?

[ScottGem]

First, you need to use a listbox if you want to all multiple selections. There are several ways to handle this. If you want to use a Temp table, then you would need to cycle through the ItemsSelected collection writing a record to the temp table for each one. If you check the Help on Multi-select it will give you sample code for this.

P.S. please don't ask questions via PM. I will see any questions posted to this forum.