list box

H

hlam

I have a 2 columns drop down list box in form that I would like to pick up
the value of 2nd column and display in a different text box. I tried to use
Dlookup to pick up the 2nd column value but that returns me with an error
"the object doesn't contain the automation object".

Can someone show me how to make it work?

Thanks!
 
J

Jeff Boyce

In the AfterUpdate event of the combo box (is this what you meant by a "drop
down list box"?), add something like (actual syntax may vary):

Me!YourTextControl = Me!cboYourComboBox.Column(1)

Note: the Column method uses zero-based numbering, so the second column of
your query would be called .Column(1).
 
H

hlam

Thanks for the reply and it works great except this will change each record
on the CONTINUOUS form. Is there a way to fix it?
 
Top