ComboBox record lookup

[schuh.mike]

I have a combo box that is on a form. The form displays a students schedule.
Each student has multiple schedules depending on which term it is. I want
the combo box to drop down, and display the students name and term, so you
can select to view a specific schedule. I ran the combobox wizard and put
both fields into the combo box, but when you use it, no matter which term you
select, it defaults to the first term of the selected student. How can i get
this to select the specific term I am trying to select.

Also, a very related question. I have another form which the student can
update their schedule. I have a combobox for the student to select which
term they want to update. I went through the wizard, but the combobox gives
me every term for every student, instead of the specific student I am
intending it for.

 

[Steve Schapel]

Mike,

I assume that you have a table for Schedules or some such, and each
record has a Student and Term. This table probably also has a
ScheduleID field, or some such, to uniquely identify each record in the
table. Whatever this field is, it will need to be the 'Bound Column' of
the combobox.

Hope that might point you in a useful direction. If you need more
explicit help, it will be easier to provide such if you can let us know
some more details, with examples, of your tables structure, and the
forms you are using these comboboxes on, and the purpose of the comboboxes.