Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am Creating a student enrollment database and I am desgining the a form
for which will be the main data entry page that the users will see. I have
set this form up so that it works quite well expect for a couple of things.
Which are this when entering new student details I need then user to be able
to select from the list of course that this student will be enrolled in and
then populate that record with this information on the form so that when they
go back through the form they can see what the student is enrolled in and it
popualtes all the correct feilds on the form with the data from the table. I
also need to be able to do this so that they can select the venue the student
will be studying at.

Thanks

Micahael
 
If the data that you require in other fields on the form is actually in the
combo box in columns, then the other fields can have the control source set
to
=[ComboBox].Column(1)
=[ComboBox].Column(2) etc.
 
Can you give your table structure for the student, course and venu
(plus any other tables specific to the term)
 
Back
Top