-----Original Message-----
when i click any items in the Combo box i want list other
feilds in text box, how can i .
Regards
Include all columns in your combo box. Set their width to
0" in the Column Widths property if you don't want to
display them in the drop-down list.
To display one of the columns in another textbox, set its
Control Source using the Column property of your combo
box. It's zero-based; the first column is 0, the second
1, etc. For example, if your combo box' name is
cboCustomerID, and you wish to display the third column,
set the textbox' Control Source to:
= cboCustomerID.Column(2)
HTH
Kevin Sprinkel
