Unbound Combo Box-Controlled Form

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?
 
A

Arvin Meyer MVP

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a combo box to add records 4
Either/Or Combo box? 4
Combo box form 1
Unbound Combo Box 5
Access Form - Lock Fields from Editing 0
Combo Box not putting information into form 2
Combo Box, Unbound Text Boxes 2
Lookup Box on an Unbound Form 1

Top