combo box

[kimberly]

Using Access 2000-created Main form with a combo box that
looks up persons with 3 columns. How do I get all 3
columns to be visible AFTER a person is selected?

 

[fredg]

Using Access 2000-created Main form with a combo box that
looks up persons with 3 columns. How do I get all 3
columns to be visible AFTER a person is selected?

Use unbound text controls for the 2 that don't show.
Code the Combo AfterUpdate event:

[ControlA] = ComboName.Column(2)
[ControlB] = ComboName.Column(3)

The above assumes Column(0) is the hidden bound column.
Column(1) is the column that does show after selection.