Textbox and Combo box.

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

I have a combo box base on a query on a form. The combo box has two columns
name
Accounts and accountsID. I also have a textbox on the form with the combo
box.
How do I enter the accountsID number in the textbox and have the account
show
in the combo box?

Thanks
 
I have a combo box base on a query on a form. The combo box has two columns
name
Accounts and accountsID. I also have a textbox on the form with the combo
box.
How do I enter the accountsID number in the textbox and have the account
show
in the combo box?

Thanks
Click to expand...

Set the control source of the textbox to

=comboboxname.Column(0)

The Column property is zero based, so it will display the first field
in the combo's recordsource (the account name, if I understand
aright). Set the ColumnWidths property of the combo to

0;1.5

to conceal the accountname in the display of the combo.

John W. Vinson[MVP]
 
Back
Top