Get the free probation check in online form

Video instructions and help with filling out and completing probation check in online

Instructions and Help about check in probation form

This tutorial will discuss how to filter a form using a query or how to filter a report using a query and through the query we will filter through a form, and it's confusing as that founds it looks like this, so we would have the same database that we used in our how to filter a form tutorial, and we'll have a combo box we'll be able to open up the combo box select criteria and then use the command button to generate a report, so this is our database at this moment we have these three tables each table holds this information and if we want to know all the details on a report according to what we want to use as far as client the first step would be to build a query, so we'll build a query with all three of these tables and let's say we want according to what you want to filter, so we want to filter client use client ID client name don't use this client name if we want to know client city state Willis through all of these options in there and if we run this query it will give you all this information, so this is all the information in our database so if we open up this query again, and we know that all of our information is generated when we run the query if we want to filter now we'll choose client ID to filter by the best thing to do would be to create a blank form as we did in the other tutorial good sign you select a command button and in a combo box you want to select client table is what we're going to be filtering by you want to select client name and client ID you can put it whatever order you want to it doesn't matter here you have the option to hide the key or to show the key and all this will do is whenever you activate the combo box it will bring a drop-down menu and these will be your two options and save it under whatever name you want to in the database so here's your combo box and the text box associated with it and if we open up the properties tab and select the combo box only you can go to other and see the name of the combo box one, and you're going to want to save this form, so this will be the name of our form and from here we can close out this report, and we can come down here to this query and filter client ID, but before we do this the best thing to do would be to save the query and to build a report on that query so if we go to create tab, and we go to report there's a lot of different reporting options we will just use whatever the basic report is you can change any of these however you want them this is just out of the box, and we'll leave it out of the box for this save it as a report tutorial, so we can go ahead and close this out we can go back to our form and what we'll do is we will go ahead and activate our combo box by going to build in a will right-click go to build event macro builder and this can also be accessed from the property sheet if you go to it then these are all the areas that you can activate an event so if we select on click and the three dots it will also give you this menu select macro builder...