Microsoft Access 2010 Tutorials
Data Forms / Using Combo Boxes pt. 2
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Microsoft Access 2010 / Data Forms / Using Combo Boxes pt. 2)
Welcome to using Combo Boxes part two. In part one, I went through the process of setting up a look up Combo Box, that we can use to populate Controls alright? And I compared that to the alternative of using an actual look up field in the table. Now once you're thoroughly confused with that concept, let me confuse you with this one. This is actually not a confusing concept, it's very straightforward, this one is magic. We are going to create a Combo Box that will look up whatever record we want to see, without having to next and previous through all of our records, looking for them, alright? The way we do this is we're going to use the Control Wizard, and we're going to drop yet another Combo Box on here. And so what we're kind of doing here, is creating this little Control Panel, I guess you could say. This is not the best informed layout, but I'm just trying to teach functionality OK? If you want art you got the wrong guy OK? Its, I historically, have had other people handle visual aspects of the Interfaces, some people are just talented that way, and some of us, not have a way, as Steve Martin used to say. So there is our Control Wizard, notice I went into Design Mode, while I was running my mouth there, and so we're going to go out here, and make sure that User Control Wizards is on, I'm going to click on my Combo Box again, and this time, I'm going to drop this one right up here, near the top. I can re-locate these later. The Combo Box Wizard pops up, and notice I can choose to let the Combo Box get the values from another table, not what I want to do, I can type in whatever values I want, not what I want to do. Notice this is the interesting one, find a record on my form, based on the value I selected in my Combo Box. That sounds cool. Choose that, hit Next, and what fields do I want to look at? I want to see a choice of first name, last name, and then I will hit Next, and notice I will just double click here, so that they show up, and again, I'm going to hide the Key column, nobody wants to see the SIDs, and I hit Next, and I will call this CB Choose Name. So if I ever want to program, this is going to be the name of that Combo Box alright? Click Finish, and I want you to notice the magic that just got created there. Go back into Form View, now I click this, and I want to see the record on Suzy Hanks, I pull it down, boom, there's Suzy. None of this, moving next, moving previous to try to find it. I can just go up here, and say I want to see John Smith. So I'm in the store right? Jimmy Smith walks up, wants to do something about his account, boom, I just hit the drop down, there's Jimmy Smith. So very, very cool and again keep in mind, let me go back to Design View, let's say that I want to move all this around OK? I am going to highlight all of this, and then I'm going to use my Arrow Key to move everybody down just a little. I'm going to lose this irritating Label that I don't want, and then I'm going to grab my drop down box, my search box, put it up here, come over here, and make it the width of my other Controls, OK? Close enough, go back out to Form View, how cool is this? Alright? Show Little. That's another way to use the Combo Box. Now what I'm trying to do is give you some hints as to how you can use these Control Wizards, grab different Controls, and it will just step you through some of the cool things that you can do on your Forms to make magic happen. And what we're really trying to do, is help the end user do cool things, find their way around very easily, make it intuitive, work on your form design, move some people around, re-size some people, change some widths, all that sort of thing, and you can get some cool stuff happening, very, very quickly OK? So that's using Combo Boxes part two, I hope you're really beginning to get dangerous with your Forms, with your Control Wizards, and your Combo Boxes, and I hope I've opened a new world for exploration up for you, with some of the cool things you can do to your Forms.
Tutorial Information
| Course: | Microsoft Access 2010 |
| Author: | Mark Long |
| SKU: | 34224 |
| ISBN: | 1-936334-91-7 |
| Release Date: | 2011-05-12 |
| Duration: | 9 hrs / 121 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
