Combo box isn't displaying selected records correctly.

[Melle]

(Win2K, Access 2K

I have a form where the user can add, edit, or delete courses from a list, and have set up CourseName as a combo box, where the list of course names and the courses' start dates appear. However, when I select an existing record from the combo box, it doesn't populate the form with the rest of the record, i.e. the CourseID, Trainer, Start and Finish Dates don't update (so the record relating to the visible CourseID just gets over-written). How do I fix this so that when a course is selected from the list in the combo box (it's a combo box so that new course names can be added in that field) its corresponding fields populate the rest of the form

Thanks.

 

[Ayala]

i think that what you need is an unbound combobox
displaying the combobox and if you need also the courseId
hidden.
code the after update event of the combobox in order to
show the courseId or coursename that matches the one
selected on the combobox.

If you give more info maybe you can get more help. for
example you have an unbound form with the combobox and a
subform? you load the subform after updating the combobox?

hth,
Ayala

-----Original Message-----
(Win2K, Access 2K)

I have a form where the user can add, edit, or delete

courses from a list, and have set up CourseName as a combo
box, where the list of course names and the courses' start
dates appear. However, when I select an existing record
from the combo box, it doesn't populate the form with the
rest of the record, i.e. the CourseID, Trainer, Start and
Finish Dates don't update (so the record relating to the
visible CourseID just gets over-written). How do I fix
this so that when a course is selected from the list in
the combo box (it's a combo box so that new course names
can be added in that field) its corresponding fields
populate the rest of the form?