list box

  • Thread starter Thread starter hlam
  • Start date Start date
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!
 
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).
 
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?
 
Back
Top