MS Access Controlling Subforms from Combo boxes

we're gonna look at creating a pulldown combo box and actually having a subform that when we select say Morty number seven to show you what courses are in so we're having a combo box actually drive the subform selected to look at how we do this now the first thing they need is to create a form and we're just going to create a blank form so it's going to create a form in design view now the first thing we're going to do is select the form so it's got a square in the top and we're actually going to bind this form to an actual table so it needs to be bound to table students because we want to get the student ID next I'm going to select the combo box and I'm just going to draw a square box on the stage now what this does is give me some options but this time what we want to do is find a record on my form based on the value I selected in my combo box so we're going to select the very last one and click on next I still want to see Stu Knight any first name last name date of birth click on next and uncheck so we see this June my date and we're gonna call this selected student so we know what the field is and click on finish the next thing we need to do is actually create the subform so we're going to head up and once again we're going to go to create and we're going to go into our form wizard and I'm gonna select this time the transaction table so I'm gonna go up and go enrollments and I want to see the student ID the course that they're in and then I'm gonna head into courses and I want to get the title of the course that they're enrolled in do you want to see costs etc you can do so at this point I'm I just want to see title it's going to click on next I want to have seen ID course title click on next and this time because it's just going to be a view going down the page I'm just gonna go datasheet next and then we're going to give it a name so in this case here yes frm students student enrollment and click on finish so this will create my form which I can then close and once again I can take my own student enrollment and drop that on the stage much the same we did with the form subform in previous videos I'm not going to worry about making it look better and adjusting the look of the form but I'm just now going to run it and at the moment you can actually see that one is selected so if I go through inspect student number seven you can see the fields associated that will come up at the moment I can edit so you can turn those parameters off as well now to do that what we're going to do is go into the design again I need a select form and in underneath data allow edits we can turn to no we can also turn off additions and also deletions so this way the form won't be allowed to be changed so now when I head back in I'll just go command s and say my form so this would be if our M and we'll call it a student enrollment and click on OK when I run this as I select the student now so we go to Rick and if I try to edit down below I can't and I can't make any adjustments either if I select on other options if you have a look around my youtube channel you'll also see tutorials on creating your own personal navigation and this will help improve the form so I hope you found this tutorial useful give it a like subscribe to my channel have a look around my youtube channel as well for other useful Access database tutorials and other tutorials on creating databases and I wish you all the best in your database development

Channel: Leon Marsden

Views: 34,216

Rating: 4.9282513 out of 5

Keywords: MS, microsoft, combo, box, combobox, sub, form, subform, controlling, controll, entity, parent, child, relationship, database, access

Id: RedBz9x1gCo

Length: 3min 53sec (233 seconds)

Published: Sun May 27 2018