automatically updating a textbox

automatically updating a textbox

Post by RGF3b » Sun, 21 Nov 2004 04:49:13

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.

automatically updating a textbox

Post by Jeff Boyc » Sun, 21 Nov 2004 08:36:21


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).

Good luck

Jeff Boyce
<Access MVP>