automatically updating a textbox

[Guest]

I have a querry that shows part numbers and their descriptions. I'm using a
combo box in my form that lists all of these part numbers. Is there a way to
automatically update the description in another text box? If so, Can some
help me get started with this.

Any help would be greatly appreciated.
Dawn

 

[Jeff Boyce]

Dawn

How does the "text box" get updated in the first place?

One approach would be to insert code in the AfterUpdate event of the combo
box, and have that event "tell" the text box its new value (description),
with something like:

Me!txtMyTextBox = Me!cboMyComboBox.Column(1)

where Column(1) refers to the second field/column in the query that feeds
the combobox (zero-based counting).