subform question

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

Guest

I made a form thats split into two parts textboxes and subform. I want the
information to show up in the subform based on the input of one textbox. For
example, I have a form with the textbox fields teacher_#,fname, lname and
course on the top of the form. On the bottom of the form, i have the same
fields in a subform. After i enter information in the teacher_# textbox, i
want the information in the textbox to show up. Is this possible?
 
Instead of the Text Box for teacher_# create a combo that includes all the
fields
Select [teacher_#],fname, lname, course From TableName
In the Row Source
=========================
In each of the other Text boxes write in the control source
fname
=[ComboName].column(1)
lname
=[ComboName].column(2)
course
=[ComboName].column(3)
==========================
Its bette then openning a recordset or using Dlookup everytime you update
the teacher_#, the user can also type the teacher_# in the combo, he doesnt
have to select it from the list
Don't forget to change the ColumnCount Property of the combo to 4
 
Back
Top