access value in bound column of list box

C

craig

How do I access the string in the bound column of a list box?
I have a list box with 3 columns. I want to;
1. Use the value in the bound column to update another field
2. Use the value in the second column as the value to write
into the column
3. Use the value in the 3rd column as a descriptive value
only the user see.

Is it possible? How do I do it?

Craig
 
J

John Nurick

Hi Craig,

You can use the .Column property of the listbox to get the values. There
should be an example in Access VBA help for "Column Property"
 

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

Autonumber field in Excel that behaves the same as Access 0
Unable to display values in 2nd list box from 1st list box selection 2
Drop down list control value in vba 2
Word VBA - Automatic change content of a cell in table using dropdown list 5
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Remove Identical words 0
combo box - bound column 2
Excel does not accept text format! 0

Top