Unbound Combo Box-Controlled Form

  • Thread starter Thread starter iamnotapainter
  • Start date Start date
I

iamnotapainter

I'm new to Access, and trying to create a personnel form out of a table with
several columns of information varying per individual. The form has a series
of tabs corresponding to different types of information. My trouble is
getting the combo box (which lists all personnel names) to generate the
corresponding individuals' information below in the form-tabs when I click on
any name. In essence, iIneed it to re-generate information depending on
which individual I select in the combo box. Is there code I need to know/use?
 
Assuming that you can add the information as columns in the combo (although
the column widths can be set to 0") just add unbound text boxes with
controlsources like:

= Me.cboComboName.Column(2) ' 3rd column
= Me.cboComboName.Column(3) ' 4th column
= Me.cboComboName.Column(4) ' 5th column
etc.
 
Back
Top