Conditional Combo Boxes on a form

[ThebigCt]

I am creating a form that needs to pull information from other tables. I need to be able to select what year and semester from a drop down. Then in the next combo box I need it to pull information that is only available during that year and semster.

Let me know if you can help or if you need more info

[June7]

This is cascading (dependent or conditional) comboboxes. Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in Access Forms: Control Basics section.