show id and name on form

S

SharonInGa

I need to bound only the ID field, however, I want to show the asscoiated
name to each id in the form as well.
 
J

John Vinson

I need to bound only the ID field, however, I want to show the asscoiated
name to each id in the form as well.
Click to expand...

Simplest is to use a Combo Box to select the ID; include the name in
the combo box's RowSource query. Put a textbox on the form with a
Control Source

=comboboxname.Column(1)

to display the *second* field in the combo's query (the Column
property is zero based).

John W. Vinson[MVP]
 
Top