Update Fields

[Guest]

I have a form which we enter our production batches into, one of the fields
is a combo box which gives us that ability to select different stock codes
that we produce for different clients from the stock table, I would like to
be able to update the next field with the description of the stock
assocaiated to the stock code selected from the combo box.

 

[John Vinson]

I have a form which we enter our production batches into, one of the fields
is a combo box which gives us that ability to select different stock codes
that we produce for different clients from the stock table, I would like to
be able to update the next field with the description of the stock
assocaiated to the stock code selected from the combo box.

Why?

Storing the description redundantly in another table is neither
necessary, nor beneficial, nor good design!

To *display* the description (without storing it) include the
description in the Combo's Row Source query, and put a textbox on the
form with a control source

=comboboxname.Column(n)

where (n) is the zero-based subscript of the description field.

John W. Vinson[MVP]