Combo Box

  • Thread starter Thread starter Merv R
  • Start date Start date
M

Merv R

I have a combo box in a form, it draws it's information from a table with two
fields
description and price. I can bind either one to a field (control source) in
my form, but I wish to bind both fields i.e. when it puts the description
into say field one I want the price to go into field two simultaneously.

Merv R
 
Merv,
In the after update event of the combo

Me.TheControlName = Me.TheComboName.Column(1)

for the second field.

Jeanette Cunningham
 
Back
Top