combo box

  • Thread starter Thread starter kimberly
  • Start date Start date
K

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?
 
kimberly said:
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?
Click to expand...
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.
 
Back
Top