How to Create Search Multiple Items Using List Box

hello we come back to my video tutorial for makers of XS in this video I will show you how to create a search multiple item using the list ball I will frame that asking for how to create a search multiple item for my combo ball in previous video I will show you how to create a search using the combo box like here this example using comma Bob now we select the tie-up customer and we show already the tight that means me in this combo ball is show re one tie and at home how about if you want to select multiple tile customer I select business and government and and to shoulders resolving the same time by using come about well we cannot do that come over is already referred to one single item we have another ordinary way or will go back to do that we use a lace Bob least Bob is be able to sleep more than one item now I'm going to use this form to create a search a multiple item by using lease pop and go to this piece I've you can delete this one up I don't need that now we need to insert the list Bob is in here please walk in here I will get the least bulk of a customer time we'll select customer tie table and this at all you see is insert border ID and the time we saw it by the time and we tie the ID king are the key column you see the a primary key and behind it but even though I hide these are least Balkan a refer to the ID to the number or indicia when we link to the data okay for me oh okay is cut up a little bit and they move it up err now after we got the list love you I wanna change this name the programís i'll is 68 are they put in Airway this customer time okay and then we add a button it our search button okay and under this it can put change the name of CMD sir also we want to select multiple item from the list normally when we input the list book here is it by the phone it cannot be silly or it one or single item now we need to come back to the property or it happened multiple silicon we chain to simple to able to slip move more than one item beautiful now we can select more than one item thing here here we select this two item and we click on the search we want this data sheet is changing already that custom with Heidi matching like the item we sleep from the list ball we need to put some code may be good under the assertions a button here open the design wheel and I will click on the search button a click away in position to put some code in there when we create the search whatever we see right now from the list and will be euros we've using the searching item as foreign swing pass string we're the follow follow item in me we have the list customer time dot select it useful ish okay and makes loop Nick one item the I am assuming form the list item selected and the SI to sting search in protesting search customer hi dot item Daraa Wow hide if the Kobe put in schedule after we done the lie your name will be automatic Oh capital after loop and maybe tasting evening strings so XI equal to 0 is mean no item selected then if it has equal to sew it on for table customer it mean even though I am selected from the list and maybe show all the data on this uh data sheet form else if is the data selected if it puts sushi right - Tass equal to and the same thing over here we just copy the sequel statement but we need to put somewhere pause in there where customer ID code or in in the selected in the stream social India and vsi the commander a pie a pie fill the task done make sure we need to put some or you can message here for us M is Bob sting so you want to see whatever the VC like at this show and the message ball you want to see what is selected in there you go to do this for you and we sit here and the thumb the area box fishing the code is and here we need to put the comma between at the item that one we selected and this one need to be minus one I will explain to you later why we use a comma and YB minus one here say let the do go to from view okay we try here we got the message this comma but three two one and as well because it's your individual business and government we see the government and initially searched two and one when's confirm two in one as this one remembered the lease ball is linked to the ID or customer type ID from the customer table here epic routine you see one and two is an individual in government we caught the list ball is linked to their ID we can go to the side view and click on this ball and click on data you can see the data source here we create and then where's come from Wesley Watling you see the ID is the first feel here and second is a time now it's linked to the first year which is ID we can see the data here that how is issue the number now when we have the number s Y on the code we use a comma because we want to separate the number of a comma it used is comma and we on the code we eat the data or have the item selected from the list ball we use we make it shorter cut out the first comma you can see here the right we start from the right of the string and then go to the left-hand side and minus one is mean leave the one don't call the first one on the way it start from the right that how it we can see from here another message ball okay we want to see the number before and after we eliminate the first letter we can see the full time we have the comma here and it's a crime the same comma is re 3 comma 2 and search it with business and government that are we used that right function and with the link function now our code is working however if it's like many now I wanna add a new button to create this list how can you do that I just add one button and name it as clear Prius okay under the click button need to add some code here create button is sim similar to add the item to the list but this one to create the item from the lid they still need to use similar on here copy and drag into here okay when we clear we also need to show all the data and now and we need to copy this part and also this here a pride okay now we add some more in here if please customer dot MOU this silly equal to zero in mayors customer I forgot the time they customer time okay now its capital and supposedly if nothing's working there and now aside the least to know something else keep some data had been selected from the list and then we go to this for rope and then we aside we saw the list not so much at i dot item data equal to for whatever data slick in their equal to four is clear and then next okay let's try to clear out the affinity code okay cream here okay have some air in there okay when you put some B's step in here else and you need to it pause it and if clear object with wine okay this one is not right dark selective dot selective I damn equal to four it's me don't select anything and this part we don't have to use it oh we can use that leader filter you see fuel on equal to four maybe don't use the filter after we clear the list clear that's good we say okay and then we keep clear the list now we put the filter filter on here made a few on equal to four and after we created and then we sit no future it's mean show all the data on the list or from the data from the customer table now this is an individual we search it you see all the civic order individual customer time as an individual issue on the list after view search or filter now we just go update the code a little bit and take out a message Bob we don't watch showed it because everything's working fine and now we wanna see house worked right way and create a show all the data from the table on the datasheet part and the Civic two-tire customer and we search now we'll be show re visited and comment I hear or individual Ian search again okay we can add some more function in a implement the code here after we select is time we want this Donna change it right away we don't have to click on search or we can eliminate the suit of our button let's go to the the code window maybe a now we can make this pot as like a sub Oh functions search okay and it's up now that's us button we can call a search function so it's up okay now we need to a good make go to design view under after update you win on the list we put the whole given position and see at the power of n and we call search when we click is Tom and then we call this function here and then update the list right away we don't have to click on the search button click on individual is the individual show right way or nonprofit add it on a chameleon edit our dance we search it right way after pickup select item from the list and we can clear and by this clear this is how we create the search multiple item from the list blog or using the list ball we cannot doing this on the combo bar but we can use the list book to select multiple item in the same time and then search for the data thank you for watching this should help you to be prevent your database of how to create a search multiple item by using only spot thank you

Channel: T Golden Eye

Views: 56,809

Rating: 4.7478991 out of 5

Keywords: List Box, Search, Business, search multiple items, search multiple words, search using listbox, How to, Ms Access, Create search, using list box

Id: EH2c082HJ_s

Length: 21min 8sec (1268 seconds)

Published: Sun Sep 06 2015