Combo Box in Forms

[arpitraval]

I have a table in which i have three columns. first columns contains semesters, second column contains enrollment count. third column contains department. there are three different semesters for example 2008 spring, summer and fall. departments are electrical engineering, mechanical engineer, computer science. So now the total number of rows are 16 so here terms are repeating so many times. now below is the thing which i want in form. You can do that in the database which i sent you with zipped folder.

I need a two combo box and one text box. in first combo box i want three semesters so that i can select one of them so once i select them now i have to select the department in the second combo box. again here the departments are repeating in the main table but i want them only one time in the combo box. so once i select both i want to have the numbers automatically in the third box which is text box that how many enrollment numbers in that particular department. I hope i can make you understand this.

Thanks
Arpit Raval

 

[CyberLynx]

This is your third post on this very same topic and you were supplied a solution to this. Obviously you didn't understand how to implement that solution. Please try to keep one thread going on the same topic rather than creating a new one.

Attached is your sample DB with the solution provided earlier included (run Form1).

.