Working of Combo boxes in Form

[suryaprasad]

Hi Attached is the database where i have 2 combo boxes in the first combo box i have the roll no and in the second i have the roll no & Student name, for which i have assigned the first combo box to roll no & second one to student..now what i want is when i click on the first combox i need the get the data of those roll no in second combo box..is there any query to work..here is the attachment.

[TheShabz]

Check out this link.
Cascading ComboBoxes

[suryaprasad]

Hi

Thanks for the help..but can you please do it in my database which was provided i was bit confused about the procedure

Please help

[TheShabz]

I cant as I am not at work today. It is pretty simple. Just follow the directions. It's best to figure it out on your own as cascading comboboxes are commonly used.