if you use a combo box, with 2 query fields [id],[name], then hide the ID field using col widths: 0;2
then the field gets the ID, and the user can see NAME. win/win in a single box.
if you want to do the 2 box thing, ...same settings, except show the combo box ID field and hide the name: 1;0
then in the combo AFTERUPDATE event, fill in the text box
Code:
sub cboBox_Afterupdate()
txtName = cboBox.column(1) 'NOTE in vb, control columns start with zero. so col 2 in the property is cboBox.column(1) in code.
end sub
or use a subform....fill in the ID box, the subform loads all the data for the ID.