Drop down subforms

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

Guest

Okay, this is what I want to create. I thought it would be easy, perhaps I'm
just having a mind blank, but I can't figure it out.

I have a main form with course information.

I want a subform with student info - name, location and contact info.
I want this subform to work in such a way that once a student is added once
I can choose them from a drop down menu and it will display all the three (or
more) pieces of information will be shown, not just the name. to save
retyping this info for repeat students.

I know I will 'duh' when I hear the answer, but I just can't figure it out!

Thanks in advance!
 
Make your "dropdown" really called a combo box, a multi column combo. Then
you can add the other information in the After Update of the combo using the
column property.
 
Back
Top