Combo Box

[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

 

[Jeanette Cunningham]

Merv,
In the after update event of the combo

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

for the second field.

Jeanette Cunningham