From the course: Access 2016: Queries

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use a combo box to select criteria

Use a combo box to select criteria

From the course: Access 2016: Queries

Start my 1-month free trial

Use a combo box to select criteria

“

- [Voiceover] In a previous movie, we created this customer look up form here, that will allow us to enter in a state name, such as California, and run the query that will show me all the different customers that live in the state of California. Now this functionality can be improved a little bit because, for instance, if I misssed typlisting, let's say I added an extra -a to the end of California, press run query. The query that returns doesn't show me anything. This form that we created is not telling me all the states that are available, and it's also not helping me spell them. One of the things that we can do to improve this is to convert this text box into a combo box. There will be essentially a drop down menu of available selections that we can make a choice from. Let's go ahead and see how we can do that by taking this form and switching it into design view. The first thing that I'm going to do is select this text box here and just press delete on my keyboard to get rid of it.…

Contents