I'm making a database for a local school, and they need a form which lets them keep track of students assignments, and in turn the grades for that assignment.
So i have a form with all the basic controls on, what I want to know is, can I auto populate a combo box depending on what a user has already selected on a previous combo box.
So for example, I have a combo box called "Course", this is just a course present in the school, Computing for example.
Under that is a combo box called "Module", this is a part of the course. First i want that to only contain modules that are present on the already selected course (Programming for Computing, for example)
AND then (:-)) is another combo box under the module called "Assignment", I want that to contain only assignments relating to the Module selected previously.
Finally, there is a student combo box, which i want to only contain the students actually on the course previously selected.