Cascading combo boxes

[kirtney]

Hi guys I am a novice user of access. I am trying to create a form that allows me have a combo box that when i select a class the next combo box shows me all the students from that class. I have gone through all the suggestions in the forum on how to do it and i am lost. The tables i am using are as follows
class - Class ID , Class Name
Student - Student ID , Student Name, Class ID
Can you please help by giving me step by step instructions on how to do it and the visual basic scripting that i needs to be used to make this happen

thanks very much

 

[pbaldy]

Here's a sample:

http://www.baldyweb.com/CascadingCombo.htm