Combo Box In a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box listing products in a table. Column A list the Product ID
Number and Column B list the Product. When I enter the ID number in the
combo box, I'd like the product to be displayed in a text box. Is this
possible? If so, How is it done? I'm using Access 2000.
 
Larry,
Use a calculated text control with a RecordSource of... (use your names)
= cboProductID.Column(1)
Combo box columns are referred to as 0, 1, 2, 3, etc... 0=ID, 1=Product
This will always "display" the Product slected in the combo.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top