Multiple Column List Box

B

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.
 
B

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
 
S

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
 
B

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
 
B

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.
 
B

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
 

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

Top