Choosing all items in a combo box

[angiew]

I have a rather large database with multiple tables and queries.&nbsp;&nbsp;The ultimate goal is for a user to open a form and choose options from combo boxes that will in turn generate a report directly from the form.&nbsp;&nbsp;The user will need to have the option of choosing all items in the combo box menu.&nbsp;&nbsp;I am not sure how to do this.&nbsp;&nbsp;The items listed in the combo box come from a table that I have created for each combo box.&nbsp;&nbsp;All that is listed in these tables are the items to be listed.&nbsp;&nbsp;Am I approaching this correctly?&nbsp;&nbsp;If so, how to I allow all items to be chosen?&nbsp;&nbsp;The form will not be used to add any new items to the tables, only to specifiy which items to print on the report.<br><br>Thanks!<br><br>Angie Wenzel<br>

 

[dirkg]

For this purpose you have the list-box instead of the combo-box for which you can use the multiple-selection option. In the Help from Access you will find some nice examples what you can do with Listboxes. Search also for topics about ItemsSelected, Itemdata and Selected.<br><br>Hope this helps,<br><br>Greetings,<br><br>Dirk

 

[JimConrad]

Combo box controls can only be used to choose a single value.&nbsp;&nbsp;A List box control has an additional property (MultiSelect) which allows the user to select one or more items.<br><br>But I'm not at all sure just what you are attempting to do.&nbsp;&nbsp;Are you trying to use the choices to filter the data for the report?&nbsp;&nbsp;Do you open the report using code in the form? <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>