G Guest Nov 9, 2005 #1 I need to bound only the ID field, however, I want to show the asscoiated name to each id in the form as well.
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 Nov 9, 2005 #2 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]
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]
