connecting parent combobox to child comboboxes

[aparnawangu]

Hi
I am working on Access 2007 and i have to make a form in which i need to display total 3 comboboxes.
One will be parent and other two childs.
In parent combobox i need to display student Name and i am using a student detail table for this.
In 1st child combobox i need to display program name ie which program the student is in.eg todd,Infant etc.
In 2nd child combobox i need to display plan name ie which plan the student is in probably one plan per child eg:Regular or any corporate like IBM,Accenture.

Pls help me with coding part.I am very new to access.

[June7]

If you mean cascading or dependent comboboxes, review http://www.datapigtechnologies.com/f...combobox2.html

[aparnawangu]

Thankyou so much for the stuff.Very helpful.I need one more help pls provide me the third combobox code also.In the video there is linking of two comboboxes shown what about the third that code i require.

[CJ_London]

try this one instead which has 3 combo's

http://www.access-programmers.co.uk/...d.php?t=275155

[June7]

It would be the same technique for however many comboboxes you want.