combo box in access report | access create report from combo box | combobox

[Music] welcome to rover youtube channel rover is going to teach you how to populate microsoft access report automatically using combo box value okay let's go to the video do not forget to subscribe rover today i am going to explain you the way of populating ms access report by using combo box so once you create the combo box it is like this you can select values from combo box so according to the values you select report will populate according to the combo combobox data for this purpose i have created sample database so i have named my database as sample and already i have created table microsoft access table called test so this is the table i used to generate my report so this is my main table to do this task firstly i have to create a microsoft access form to create the form i am going to click on the create tab then select blank form so this is my new access form so i want to rename this form so i want to save this form as farm test so this is my form name from name is frm test so now i click on the ok button so this is the form so i am going to add combo box to this form to add a combo box i just right click on the form and go to design view then you have to drop combo box from a design tab here i added combo box to my form then once you add after you add the combo box then you have a com you have a message box like this so there you can link your combo box to existing table or otherwise you can type combo box values manually so here i am going to type combo values combox values manually s a g or vt so these are the values i am going to insert my combo box then click next then you can give a name for your added combo box so report so this is the label name of my combo box then click on the finish button so now i created the combo box then i want to increase the font size of my combo label yeah then i want to increase the values of my com uh i want to increase the font size of my combo box now i want to uh name [Music] my combo box by right click then go to properties there you can give a name to combos here i am going to name this combo box as cbo test right so this is the name i give my combobox cbo test it's okay so after giving the name then i want to create a query based on my table so to create a table just click on the create tab and and select the existing table and press add now the table is added so there you can select desired columns as you wish so here basically i am going to add id branch open date account number [Music] and the its name will be customer name so these are the columns i go i'm going to add my query now once you added this um columns to a query then basically you have to give a small criteria based on the product so this product is the criteria selection criteria of my combo box therefore here i have to give following criteria so click on the criteria under the product column then right click and click on the zoom you have you can do this you can type it here itself open square bracket forms then select the form name select the created form it is frame test then we have to select the combo box name so we have named the combo box as cbo test yeah now we now i give the criteria under the product column then you can save your query here i am going to save my query as qry test so this is the name of my query then press ok then you can just you can check whether the query is run properly then click on the run button on the design tab yeah my query is [Music] running now close the query now you want to and the next thing you should do is you have to create report based on the based on the created or the based on the existing query then click on the qri test then go to create and click and click on the report wizard then select the desired column to generate the report so i select [Music] these are the things i selected for my report [Music] then click now then you have to name the name your report here i want to name this report as rap test just then click on the finish button now we created our report so create report is like this now we are going to uh do the coding part then we have to add a small chord to our combo box we have to add a small vba code to our combo box to add the combo to add the vba course you have to click on the combo box from the form design view and right click then build event then select code builder press ok so you have to add your command to your combo box under the aft update event select the after update under the cbo test so here you have to type your vb according this is the coding the [Music] dot [Music] open query then you have to give give the query name so our query name is qry test then open the inverter close the inverted commas then comma ac view normal ac view normal then ac edit right in the second line do cmd dot open report [Music] then the report name out name the report as rep test rap test [Music] right so third line do cmd [Music] comma close clause we are going to close the query then give the query name as you query open inverted commas and q are y test yeah then we have to close the [Music] poem and this is the fourth line do cmd dot again clause [Music] ac form [Music] then give the form name so we have named our form as frn test [Music] rm test yes that is it so we added recordings and we completed the coding part now save the vba application then go to access again [Music] then you can run your [Music] form then click on the [Music] form view yes now let's check what will happen so here i am going to select sa govi yes when i once i select the value the report will open and show the desired value so just take another one i am going to use it yeah here you can see this is the value i am going to select here this is the value i am going to select okay [Music] yeah so once i select the value report automatically populate the desired product so this is how we can use combo box to populate a report according to the combobox value so if you have any questions please add them to the comment section and so don't forget to subscribe my raw youtube channel for more videos like this thanks for watching

Channel: Rover

Views: 535

Rating: 5 out of 5

Keywords: combo box, microsoft access, access, access 2016, access 2017, access vba, access combo box bound column, access combo box value list, access combo box row source, access open report from combo box, create a report based on items selected in access combo box, access report combo box, access create report from combo box, combobox in access report, search using combo box, combo box wizard

Id: CYBTilywnB0

Length: 12min 29sec (749 seconds)

Published: Tue May 18 2021