Ms Access Listbox Multiple Selection

To overcome this, I am introducing a Multi Select Dropdown list box control. MS Access: Combo Boxes. The sort options are set up by placing command buttons above each column. I will use the form that I created for How to Add Items from File Dialog to Listbox and add a Clear List button. Selected(i) Then Msg = Msg & ListBox1. This article explains how to use a multi-select list box to select several items at once, and open a report limited to those items. Using ListBox in Userform is very common. Using Controls to Limit Data Entry Choices. They can choose only one item at a time. That's a lot of 'Multi's'. Net and MS Access 2007 where I am trying to save the details of a patient like name ,age, Ticket No and Lab investigations in the database. Select multiple items from the list, and all selected items are entered in the active cell. For a ListBox that allows single selection, either set the SelectedIndex or the SelectedItem property. Now, on to changing a few settings for the list box. By default, the value is blank but when you initialize or refresh a ComboBox or ListBox, you may want to select the first item in the list. Imagine my surprise when I discovered that not only was such a capability not present in the properties, but that the authors of the control seemed to go out of. The user now sees the MS Word Document with the selected text inserted where Cmand1a used to be. I will be. Looping through multiple select list box items in a Microsoft Access form and inserting the values into a table using VBA. Now, on to changing a few settings for the list box. How to work with recordset (Dao) in MS Access. Because Combo Box receives user input, Combo Box should be used in Access Form. These can be used to help create, or improve your current application. How to create a Listbox is similar to creating a Combobox. You can set different Fore Color for the contents of every column of ListBox or ComboBox by just setting Format property of underlaying table or query to an appropriate color formatting string: [Color];@ (where [Color] parameter can be one of the following values: Black, Blue, Green, Cyan, Red, Magenta, Yellow, White). I have a dependent drop-downs/list-box in InfoPath using Filters working in a repeating table for the first row; however, the subsequent rows contain any previously filtered data. To create your list, I assume you mean you want to filter the list based on the selections made in the list box. All - For the life of me I can't get the Multiselect Listbox to correctly pass along all of the item selections to a Query which a form is based on. You can use the Add or Insert method to add items to a list box. A user can select an item from the list. SQL Query - Insert multiple values from listbox into one column in database. Multiple Combo Boxes as Criteria for A Query. id) LEFT JOIN TableC AS C ON C. This is a part one of two-part on how you can make your queries much more powerful. See Microsoft Knowledge Base article 135546 for the code and be sure to have have DAO3. There are multiple fields, such as allergies to meds or current medication, that I would like to store multiple values. Open the Visual Basic Editor. Selecting a second item de-selects the first item. Author(s) Dev Ashish (Q) I have a MultiSelect listbox control on my form. Selecting Multiple Items from Listbox. The MultiSelect property uses the following. What this does is will take the selections from a multi-select box and will apply a SQL statement to a blank Query in Microsoft Access. Assign the data in a worksheet to RowSource of a ListBox: 5. See Microsoft Knowledge Base article 135546 for the code and be sure to have have DAO3. How to create a Listbox is similar to creating a Combobox. Click Loop Selected to put the selected values into an array. Microsoft Access supports many ways of using, interpreting, or applying the SQL. Value is a table result so I was able to do the following to get the selected values. A lot of people get tripped up using the Listbox. When the Multi Select property is set to Simple the user is allowed to make multiple selections. A transparent listbox control is no exception. I've set up a query that prompts me to input the name of the contact (using [Enter Contact] on the criteria line inside the query), but it would be easier if I could have Access prompt me with a list box that has all of my contacts in it, from which I can choose the one I want to isolate. It displays a list of values that a user can quickly select from. Value if u have set selection mode property to multiple then access it through for loop as For i = 0 To ListBox1. The Tool used here is the Visual Studio 2010 , you can also use Visual Studio 2012 or Visual Studio 2008 to work this tutorial. If you found this video useful and would like to see free Microsoft Access Tutorial videos click the like button and don't forget to subscribe. In this example, I will demonstrate how to create a multi-select parameter list and pass the values to a stored procedure that will then populate the report. MS Access tools, help and tips. Find us at… YouTube: msaccessexpert. Let's create a list box by dragging a ListBox control from the Toolbox and. Now in this blog, we will discuss how to select multiple options from the dependent drop down list Box as it helps to send out the. But, ultimately, I personally choose to use a work around with a ListBox and a Form that pops up for multiple selections. We will be using a little bit of special VBA code that will make working with a list boxes a breeze. To get the data out, I generally use the Column property. First, loop through all the items in the listbox and check the Selected property. Open the Visual Basic Editor. Multiple items are selected by holding down SHIFT and clicking them with the mouse or by holding down SHIFT and pressing an arrow key to extend the selection from the previously selected item to the current item. Also, if you wish to use wildcard characters when selecting criteria in the form, so that you may enter a partial text string with an asterisk, then the line should read:. From the Help page: Use the ItemsSelected collection in conjunction with the Column property or the ItemData property to retrieve data from selected rows in a list box or combo box. The Multi-Select property of the listbox must be set to Simple or Extended in order for the listbox control to accept multiple sections. Unfortunately, VBA is not available in Access Services. If it's True, then use the Column. I recently shared how you can restrict data input in Excel to certain number ranges, such as whole number percentages. The ListBox has a BoundColumn property. With a normal list box or text box, you can limit your report merely by placing a reference to the control in the Criteria row of its query, e. Hello, I have a form that have a listbox and subform. Depending upon the version of Access you are using, Access may prompt you with the correct names for the form references, which is a new feature in Access 2010. so you cannot add multiple cells from Range Not Inserting new records instead it updates the last record in Ms access. Multi-Select Listbox Functions from "My Access Tips". The Userform we are going to create looks as follows: To create this Userform, execute the following steps. Select multiple items from the list, and all selected items are entered in the active cell. How to easily get a list of field names in MS Access If you have a MS Access table that has 100 fields (also known as columns), what is the easiest way to get a list of all the field names? One option is to use Database Documenter. The ListBox control is a very versatile control in that it can be used to display a list of data to select from. Selecting multiple values from List box using VBA in Microsoft Excel. You cannot do that with a multi-select. I currently have a list box that when I select a value, it updates another list box to show relevant values (for example if I select a state, the other list box will update with cities only from the selected state. One of the main differences is the fact that the ListBox control actually deals with selections, allowing the end-user to select one or several items from the list and automatically giving visual feedback for it. QueryName: Replace with the query you want to use. 3)we can select one item from multiple items in the list box. When you open a form (or table or query for that matter) in datasheet view, you are allowed the "Simple" type of multi-selection. A multiple-selection list box bound to a field will always have a Value property equal to Null. ) Once you have selected the value in ListBox, and when you navigate away, it will be set to no selection and when you return to the same screen, you will no more. These can be used to help create, or improve your current application. It will take you through how to align M Select property of list box using Excel VBA. 4)contain a check box with in the list box. Select Method. First, it needs to be a multi-select listbox control. Everything is working fine. Before you continue, you will need the following setup: · Add VBA reference to Microsoft ActiveX Objects X. Microsoft Access Multi Select List Box Database written all in Microsoft Access show how to use a select all deselect all to select multiple records from a list box. and populate all data in the list box. VBA example - Microsoft Access: if else display data in listbox VBA if else display data in listbox Statement with SELECT statement to show the data in the. Also, if you wish to use wildcard characters when selecting criteria in the form, so that you may enter a partial text string with an asterisk, then the line should read:. We help you create better MS Access applications. Selected property. To overcome this, I am introducing a Multi Select Dropdown list box control. An expression that returns one of the objects in the Applies To list. Microsoft Access Tips for Serious Users. Excel VBA Worksheet. Note: you can change the name of a control by. You can also select items by dragging with the mouse. To select an item in a ListBox, we can use the SetSelect method that takes an item index and a true or false value where the true value represents the item to be selected. If you select a filter with the Filter Name argument, Access applies this WHERE clause to the results of the filter. to filter a subform or find a record, which was what I was trying to do) you would. To save time, I'd like to be able to select multiple names and assign them to their relevant department. Value if u have set selection mode property to multiple then access it through for loop as For i = 0 To ListBox1. It requires more space than a combobox, but it also helps users see a partial list without any action to pull down the list. Microsoft Access tips: Use a multi-select list box to filter a report What I ended up doing following Allen's example is create a report based on a select query without anything in the where clause - something like. NET MVC View. 3)we can select one item from multiple items in the list box. Author(s) Dev Ashish (Q) I have a MultiSelect listbox control on my form. Value is a table result so I was able to do the following to get the selected values. RowIndex: The row index of the record we want to access. In this How To, I will show how to add an item from a textbox into a list box. This is a part one of two-part on how you can make your queries much more powerful. ListBox MultiSelect Property: Change Manually. if you want to set a selected item when you know the text from drop down list and don't know the. A user can select an item from the list. It is a little trickier with a multiselect listbox, but the code would look like this:. The Add method adds new items at the end of an unsorted list box. The SQL is equipped with keywords that tell it what to do and how to do it. In some applications you may wish to offer the user the choice to print any saved report. Open/select multiple file from MS access If this is your first visit, be sure to check out the FAQ by clicking the link above. (I recommend extended for the most flexibility. Author(s) Dev Ashish (Q) I have a MultiSelect listbox control on my form. If you found this video useful and would like to see free Microsoft Access Tutorial videos click the like button and don't forget to subscribe. MS Access tools, help and tips. Find us at… YouTube: msaccessexpert. Do I need to use a loop and check the status if selected if possible? Thanks, Yannick. By Nick Randolph; 08/06/2012; Earlier this year we took a look at working with ListBoxes in a Windows Phone application. Selected property. I want to filter subform based on multiple section in list box. I want users to be able to make multiple selections. ms access combobox data sort Sorting Columns in a Microsoft Access Listbox. Database Solutions for Microsoft Access - How to Clear a Multi-Select Listbox: If you are using a listbox on your form, you can set properties to allow the database user options as to how they make selections within the list box. Private Sub OKButton_Click() Dim Msg As String Dim i As Integer Msg = "You selected" & vbNewLine For i = 0 To ListBox1. One requires the use of an Union query, and the other one requires a callback function to fill the control. Select a weekday from the first list box. Free ms-access sample database downloads. FormName: Replace with the Form you have the list box on. TableName: Replace with the Table you want to query from. Show a listbox, when a cell with an Excel drop down list is selected. Data entry always trips over two unfortunate facts of life: Humans are fallible creatures, and typing is an error-prone activity. Using a Microsoft Access Listbox to pass criteria to a query: A Microsoft Access list box is very similar to a combo box, it contains multiple values and allows the user to choose from the list of items. Now, on to changing a few settings for the list box. It displays a list of values that a user can quickly select from. If the ColumnHead property is set to true then the first row (0) in the listbox will be the heading. select * from ufn_ConvertCSVToTable(@param,',') SQL Query - Insert multiple. I find that the Selected property does move the focus for a multi-select listbox. The sort options are set up by placing command buttons above each column. The ListBox has a BoundColumn property. Author(s) Dev Ashish (Q) I have a MultiSelect listbox control on my form. Peter doesn't like them, but that doesn't mean you have to hate 'em, too -- here's how to add a listbox or dropdown list to your View that lets users select multiple items. Add a multi-selection list box To give users the ability to select more than one value from a list box, use a Multiple-Selection List Box. How to create drop down list with multiple selections or values in Excel? By default, when you create a data validation drop down list in your worksheet, you can just select only one item per time in the list. Your Trusted MS Access Partner; Easy ADODB Recordsets and Commands in Access I don't know how to apply the ADODB recordset to a multi-column listbox, and I. From the Help page: Use the ItemsSelected collection in conjunction with the Column property or the ItemData property to retrieve data from selected rows in a list box or combo box. Populating multiple columns in a value list control is simple, if you do so manually. Now, on to changing a few settings for the list box. Figure 7-7. On the Property sheet, select Other. Setting Selected Values. RowIndex: The row index of the record we want to access. So when you need the user to select only one choice from a group of options, use radio button. One way is to "hard code" the list into the UserForm's Initialize event procedure using the. Microsoft Access tips: Use a multi-select list box to filter a report What I ended up doing following Allen's example is create a report based on a select query without anything in the where clause - something like. A popular way to let end users search for information is to provide a form with many combo boxes on it which have drop down lists of data from a table or query, then to base a query on the values in those combo boxes. Click Loop Selected to put the selected values into an array. They are Linked using Ms Access - Filter record on subform based on multiple selection in List box. Is it possible to use a Multi-Choice Selector for columns in MOSS similiar to the Query Wizard in MS Access? (can't find any tool in SPD, maybe a 3rd party is. Making a drop down Listbox with values in another table by Wyldhawke » Thu Jul 25, 2013 2:08 am Ok, I've figured out how to make a list box, how to make it a drop down, and how to link the two fields in the two tables. My listbox: ListAgeProgramStQuery on the form: frmStatusQueries. For one selection it work but not for multiple selection. A transparent listbox control is no exception. This article explains how to use a multi-select list box to select several items at once, and open a report limited to those items. Select Method. I want to filter subform based on multiple section in list box. ListBox Control The ListBox is used to display a list of items to a user. Note the rows in a listbox are zero based. Find the Multi Select property and set it to Simple or Extended. Use a multi-select list box to filter a report. For a project I have been working on for the last few months, I wanted to add in a ListBox that would allow the user to select a "block" of text instead of just a single line. ListBox MultiSelect Property: Change Manually. It has no effect. Depending upon the version of Access you are using, Access may prompt you with the correct names for the form references, which is a new feature in Access 2010. If you select another item, the first one is replaced with the new selection. Passing parameters to queries and reports can be a stumbling block for the novice Microsoft Access programmers. Instead, I have used multi-select listboxes and recorded the data using vba. You can use the MultiSelect property to specify whether a user can make multiple selections in a list box on a form and how the multiple selections can be made. Before you continue, you will need the following setup: · Add VBA reference to Microsoft ActiveX Objects X. SelectedItems collection, you can use it to build a filter like. Either would work with reports too. One practical use of selecting multiple worksheets is to print selected worksheets. Make sure the RowSource property is empty: 6. What I want is to be able to select multiple values and have those values show up in the datasheet view below the form. In this How To, I will show how to clear items from a listbox. Selected = True Then val= ListBox1. MultiSimple: Multiple items can be selected. Get all selected items in a list box: 7. I have a form with multiple parameters, including a multiple select listbox. Selecting Multiple Items from Listbox. Click Loop Selected to put the selected values into an array. Advanced programming techniques with Codes. excel vba comment alimenter une listbox à partir d un critère list box 1 math worksheet change color item of with vb net and c 2016 08 07 selected items multi. ListBox Control The ListBox is used to display a list of items to a user. You can set different Fore Color for the contents of every column of ListBox or ComboBox by just setting Format property of underlaying table or query to an appropriate color formatting string: [Color];@ (where [Color] parameter can be one of the following values: Black, Blue, Green, Cyan, Red, Magenta, Yellow, White). You cannot pass a multi list box value into the parameter of a query based on research. The type of ListBox. For a ListBox that allows multiple selection, use the SetSelected method to selected or deselect items. I'll admit, having something built in would be great, but as far as I know, there isn't - there is a count of listitems - but not selected - That's client generated (the selection of the items), you must somehow relay that to the server, so you need code (like above) to get the count. The MultiSelect property uses the following. Why this tip is too cool for school. Here is the example for ListBox Multi Select Property. You can use the MultiSelect property to specify whether a user can make multiple selections in a list box on a form and how the multiple selections can be made. Join more than two or more tables in MS Access Like the above query, we need to add parentheses for every join query to make multiple joins work in MS Access database. When the user has selected from the list. Also, if you wish to use wildcard characters when selecting criteria in the form, so that you may enter a partial text string with an asterisk, then the line should read:. Forms: Adding "All" to a listbox or combobox. Programming Combo Box and List Box Controls in Microsoft Access, Part 1 Part one reviews the various options for supplying a list of values to a combo box or list box (all but one), including one I didn't know existed, the Field List setting. That is defined in the ListBox properties window in "MultiSelect", but the property can also be set at runtime with:. I have also tried Extended. In this tutorial, I will explain how to perform the same tasks in the above scenarios using Excel VBA Worksheet. See sample database and video demo below. More Information In Microsoft Access, the value of the MultiSelect property of the list box in a form or in a report determines whether the list box is a single selection. Due to lack of information I'm going to assume that the list box is on a userform or it's an ActiveX type listbox on a worksheet. FormName: Replace with the Form you have the list box on. ListBox MultiSelect Property – Explanation & Example. Place the cursor in the form where you want the multi-selection list and then go to the Controls Task Pane ( View > Design Tasks > Controls ). In order to make use of the user's selection of single or multiple items it is necessary to use a VBA procedure to examine the list, determine what has been selected, and act on it. Access 2010: Using Option Groups in Forms Posted on November 8, 2012 by Susan Hanns An option group can be helpful in making Access client forms more user friendly when entering numeric values or yes/no fields. An expression that returns one of the objects in the Applies To list. To select an item in a ListBox, we can use the SetSelect method that takes an item index and a true or false value where the true value represents the item to be selected. See Access help for the ListBox. The ListBox control is the next control in line, which adds a bit more functionality. TableName: Replace with the Table you want to query from. This sample shows how to open a report based on a multiple selection in a list box. Click Loop Selected to put the selected values into an array. For example, the following expression selects. This list box will enable you to multi-select from multiple items and multiple columns and quickly add them to a dataset. Let’s understand with the simple exercise:- We have taken data in which we have email id detail for every employee. Identify Selected Item in a single selection Listbox This is very simple example of how to verify that an item in a userform listbox has been selected, and identify which item was chosen. Microsoft Windows allows a user to select items in a list box (in fact on many other list-based controls or views) by using a combination of mouse click and the keyboard. Holding down CTRL and clicking an item selects or deselects that item. Note: you can change the name of a control by. This article explains how to use a multi-select list box to select several items at once, and open a report limited to those items. Add Clear List button. Net and MS Access 2007 where I am trying to save the details of a patient like name ,age, Ticket No and Lab investigations in the database. Virtually anytime you need some type of data grid, you can use either a Listbox, or a continues form. ) Once you have selected the value in ListBox, and when you navigate away, it will be set to no selection and when you return to the same screen, you will no more. Populating multiple columns in a value list control is simple, if you do so manually. Because Combo Box receives user input, Combo Box should be used in Access Form. To give users the ability to select more than one value from a list box, use a Multiple-Selection List Box. From the Help page: Use the ItemsSelected collection in conjunction with the Column property or the ItemData property to retrieve data from selected rows in a list box or combo box. The best part about this approach is that it doesn't require any programming skills. so you cannot add multiple cells from Range Not Inserting new records instead it updates the last record in Ms access. Programming Combo Box and List Box Controls in Microsoft Access, Part 1 Part one reviews the various options for supplying a list of values to a combo box or list box (all but one), including one I didn't know existed, the Field List setting. A popular way to let end users search for information is to provide a form with many combo boxes on it which have drop down lists of data from a table or query, then to base a query on the values in those combo boxes. MultiSimple: Multiple items can be selected. Due to lack of information I'm going to assume that the list box is on a userform or it's an ActiveX type listbox on a worksheet. This came up on an internal mailing list: We have a secondary data source that holds a list of entries; part of the data in the list - a name field - is used to populate the items in a listbox in the view. Note the columns in a multi column listbox are also zero indexed. ListBox VBA Excel Example Macros Codes for Adding new Items,Moving all Items, selected Items from ListBox to another ListBox,clearing,Multi selection. Add List Box to Form. Instead, I have used multi-select listboxes and recorded the data using vba. Use these steps to create a simple list box in minutes that may save you hours of time. All of which pull their contents from lists within the excel book. Here you can find or see how we are enable or disable Multi Select of list box manually or using code. How to Add Items to Listbox. Access 2010: Using Option Groups in Forms Posted on November 8, 2012 by Susan Hanns An option group can be helpful in making Access client forms more user friendly when entering numeric values or yes/no fields. Please note that this is a template database. Forms: Use Multi-Select List boxes as query parameters. He wanted to make multiple selections from the. Let's create a list box by dragging a ListBox control from the Toolbox and. ColumnIndex: The column index of the field we want to access. Open/select multiple file from MS access If this is your first visit, be sure to check out the FAQ by clicking the link above. I find that the Selected property does move the focus for a multi-select listbox. They have to click on each item they want to chose (alternatively they can use the Spacebar). Populating multiple columns in a value list control is simple, if you do so manually. Double clicks their mouse and a form opens. You cannot do that with a multi-select. I have a list box that is populated from a table. A user can select an item from the list. VBA example - Microsoft Access: access vba example code to VBA select case and Database Excecute method. Your second ElseIf statement can never become true. The following code snippet sets a ListBox to allow multiple selection and selects the second and third items in the list:. How to create a Listbox is similar to creating a Combobox. The Tool used here is the Visual Studio 2010 , you can also use Visual Studio 2012 or Visual Studio 2008 to work this tutorial. Expert data entry operators can't achieve 100% accuracy (although some come remarkably close), and the rest of us can only hope for the best. MultiSimple: Multiple items can be selected. In this tutorial, I will explain how to perform the same tasks in the above scenarios using Excel VBA Worksheet. A lot of people get tripped up using the Listbox. Option Group or sometimes called Radio Button is the UI controls to provide quick, intuitive way to select from two or more mutually exclusive data values, for example is Yes or No, or Female or Male in Gender. This article explains how to use a multi-select list box to select several items at once, and open a report limited to those items. Before you continue, you will need the following setup: · Add VBA reference to Microsoft ActiveX Objects X. Show a listbox, when a cell with an Excel drop down list is selected. Implementation of CodeCharge Studio's directory and path components. Setting Selected Values. Depending upon the version of Access you are using, Access may prompt you with the correct names for the form references, which is a new feature in Access 2010. The Tool used here is the Visual Studio 2010 , you can also use Visual Studio 2012 or Visual Studio 2008 to work this tutorial. Unfortunately, VBA is not available in Access Services. Note the rows in a listbox are zero based. In this How To, I will show how to clear items from a listbox. The reason is the way Listboxes do their scrolling. Net and MS Access 2007 where I am trying to save the details of a patient like name ,age, Ticket No and Lab investigations in the database. I simply created a loop to go through each of the selected items and recorded each as a seperate record into a table. Forms: Use Multi-Select List boxes as query parameters. The MultiSelect property uses the following. This tutorial will explain about MS Access Option Group and how to create it. When the time is stored as a time(7) in the SQL server, the field in the linked table will get a text. Download - Send Email via Lotus Notes from MS Access View Details Multi-Select Listbox Functions Download - useful functions for using multi select Listboxes on forms View Details. ListCount - 1 If ListBox1. Also, if you wish to use wildcard characters when selecting criteria in the form, so that you may enter a partial text string with an asterisk, then the line should read:. He wanted to make multiple selections from the. I have tested this a little and it seems that when selecting multiple items from the listbox there is no data stored in the Control Source's underlying tables field. Value if u have set selection mode property to multiple then access it through for loop as For i = 0 To ListBox1. The above have been tested for Access 2003 and 2007. VBA example - Microsoft Access: access vba example code to VBA select case and Database Excecute method. For example you may have a list of makes of car and a report that shows various details for each make of car. The second list box will show you the date of that day this week, plus the next three instances of that weekday. Default = lb. Due to lack of information I'm going to assume that the list box is on a userform or it's an ActiveX type listbox on a worksheet. For a ListBox that allows multiple selection, use the SetSelected method to selected or deselect items. Therefor the index of the first row is "0" (zero). I wish MS gave the ability to define our "own" MVF settings (all the tables and such so they are visible to the developer), and thus give us the ability to use that sweet control on Forms and such. Hi All, My form is connected to Access db and extracts only 8 column details from a big table and display in a listbox. ) Then you need some VBA code to go through the ItemsSelected collection of the listbox and pick of the values to use in a filter. Because Combo Box receives user input, Combo Box should be used in Access Form. Multiple Combo Boxes as Criteria for A Query. The attached sample will help you to build your own custom Multiselect comboBox. If it's True, then use the Column. I'll cover the following topics in the code samples below: DB, Control, Header, Microsoft Access, Database, Report, Click, Filter Options, List Box, and Listbox. ListBox MultiSelect Property – Explanation & Example. In this article, we will learn how to create a list box in which we can select multiple names and can get the required data from the main data. VBA example - Microsoft Access: if else display data in listbox VBA if else display data in listbox Statement with SELECT statement to show the data in the. If you are trying to use the listbox to select multiple fields to be selected in a query and the sequence is to be used to control the order of the columns, then a subform works fine by itself, use a combo box on each row to select a column. Ken, an admitted Access user, needs to get data out of a MultiColumn ListBox. With a normal list box or text box, you can limit your report merely by placing a reference to the control in the Criteria row of its query, e. He wanted to make multiple selections from the. populate the list box using the row source. Advanced programming techniques with Codes. Get the selected items in a ListBox. A Listbox is also well known like Combo box in the MS Access form. The combo boxes contain the available departments and disciplines, the ListBox has names. This is a part one of two-part on how you can make your queries much more powerful. Listboxes are commonly used when you want to give users a more extensive visual representation of a list. This sample shows how to open a report based on a multiple selection in a list box. List(i) & vbNewLine End If Next i MsgBox Msg Unload UserForm1 End Sub.