How to make a form ComboBox populate with options from a drop-down list in a cell

Hi,

Not sure if this is possible... I have a row of student data that I can manually input information into each cell. I also created a form where I can select each student's name and it then populates form text boxes with the info so I can change info on the form too. One of the cells in a column is a drop-down list where I can select from a number of teacher names. When I open the form the current selected teacher's name in the cell populates in the ComboBox2 ok. What I'm trying to do is also have the ComboBox2 populate with the other names in the drop-down list so I can switch names within the form also.

Here is the current part of the code I'm trying to change so the ComboBox2 populates with all of the options in the drop-down list. Any help would be greatly appreciated.

Please Login or Register  to view this content.

Thanks! Worked great.