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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List Box Problem 2
Method to display specific records in control boxes on a form? 7
combo box data type 1
Display drop-down on form to allow user input 2
Checking if data exists another table and, if yes, extracting a value 0
Access getting values from List Box using VBA 1
Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form? 3
Access MS access forms list box problems 1

Back
Top