Multiple Column List Box

[Brian Carlson]

I am creating a form that I would like to have a multiple column list box.
The multiple fields would be Activities and Precursors. I have chosen the
Activities as the value which will be stored in the control source for the
combo box. Everything works fine, when I click on the box I see a list with
both columns. However, I would like when I choose one of the items from the
list that the Activites value is stored in the control source and thereby
displayed, but also that the Precursors value for this Activity is also shown
(though this will not be stored given it would create repetitive data). Any
ideas? Thanks in advance.

 

[Bill]

Brian,
If I understand your situation correctly, it sounds
like you need your recordsource to be a query
that returns the two fields of interest, namely
your Activities and Precursors.
Bill

 

[Scott McDaniel]

In addition to what Bill said, you also need to make sure you set the .ColumnCount and ColumnWidths values. For example,
if you have 3 columns, and want to show the 2nd and 3rd:

ColumnCount=3
ColumnWidths=0;1;1

I am creating a form that I would like to have a multiple column list box.
The multiple fields would be Activities and Precursors. I have chosen the
Activities as the value which will be stored in the control source for the
combo box. Everything works fine, when I click on the box I see a list with
both columns. However, I would like when I choose one of the items from the
list that the Activites value is stored in the control source and thereby
displayed, but also that the Precursors value for this Activity is also shown
(though this will not be stored given it would create repetitive data). Any
ideas? Thanks in advance.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Brian Carlson]

Scott:
I have all these set. However, it appears that if you use the combo
box it only shows the value being stored, whereas if you use a list box it
shows all of the columsn even though only one value is being stored...is
there any way to use a combo box and store one value but see the other values
related to this? Am I being unclear...maybe I will just have to use a list
box??

Brian

 

[Brian Carlson]

I do not know if anyone is following this post, but I found the answer to my
question. See Access Basics by Crystal. This article has a note explaining
exactly how to do what I was asking, i.e. have a multicolumn combo box store
one value in a bound field while allowing other values to be viewed on the
form in unbound text boxes. Thank you Crystal.

 

[Bill]

Brian,
I believe that those that have replied to posted
questions follow the threads until they either
become cold or the original poster posts a
successful conclusion. I'm glad you found
your answer.
Bill

 

[Brian Carlson]

Thanks Bill and thank you for your assistance.

Brian

 

[Bill]

You're welcome.
Bill

Thanks Bill and thank you for your assistance.

Brian