👉

Did you like how we did? Rate your experience!

Rated 4.5 out of 5 stars by our customers 561

Award-winning PDF software

review-platform review-platform review-platform review-platform review-platform

Video instructions and help with filling out and completing Which Form 8655 Filter

Instructions and Help about Which Form 8655 Filter

Hello again and welcome back to programming in Access 2013. My name is Steve Bishop and today we're going to be wrapping up the filtering of our continuous form. So, I'm going to go back into our Access database. Now, what we need to do with this combo that we added is give it some values for the user to select. Then, we need to have it return a value that we can filter the entire form by. So, I'm going to select the text here and go to the data tab. Remember how when we did the address type, we had a control source for it? That's because we wanted to record what the user selected into the table or query. In this case, we don't want to do that because we're not recording the user's selection. We just want to filter the form based on their selection. So, instead of a control source, I'm going to use a row source. I click on the ellipsis and that opens our query builder. This will be a select query. I add the "Customers" table and then close it. Just like with our address type, I need to add the ID field for a unique value. I also add the customer name for an easily identifiable text for the user to select from. I sort the customer name in ascending order to make it easier for the user to find the customer they want. I save the query and go back to our form. There are a couple more things I need to do with the combo. First, I change the name from "Combo 47" to "CBO customer" for better identification. Then, I go to the format and change the column count to 2 and the column widths to 0 and 1, just like we...