Could you clarify your question? I don't understand what you want to do
when you say "extract column value in list box"... I suspect you are going
to have to tell us what you have, in detail, and what you want, in detail,
rather than ask a "general question".
If what you have is a multi-column listbox, and what you want to do is refer
to one of the columns of the selected record in a list box, you can do
something like:
Private Sub lst_YourList_Click
strMsg as string
if me.lst_YourList.ItemsSelected <> 1 then Exit sub
The listbox (combo box too) has a column property (zero based) that lets you
refer to the various columns that represent the data in your list. Refering
to a particular column allows you to get information directly from the list
rather than having to requery the data for info regarding the selected item.
HTH
Dale
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.
