Mult-Value Select returning ID# not text.

D

Dee

I have a text field that is based on what is selected in a combo box. The
text field is populating but it is returning the ID numbers and not the text.
The combo box is based on a query from a form that has a combo box field
that allows Mutli-Value selections. I tried basing the field on the
uderlying table but then it only returns the one value and not the
mutl-values that have been selected.
 
K

KARL DEWEY

Try this --
Open form in design view, click on combo, double click on combo, scroll to
near the bottom, select Properties. Scroll to Column Widths and change it
form something like this 0.25"; 0" to
0"; 1.5" in order to not display first column but show the
second.
 
D

Dee

Thanks for reply but it is not the column settings causing the issue. I
think it has something to do with it being a mult-value select, and coming
from an underlying table.
 
D

Dee

I am using 2007. I have a combo box where a person selects a business
process, and then the related vendors should auto fill into a separate text
field. The combo box row source is based on a query pulling from a vendor
form and a business process form. This how I have the text field
=[BusinessProcess].[column](1) but all i get is the autonumbers instead of
the vendor names.

I should get Liberty, Harland, Clarke; instead I get 117,118,119. It is
pulling from a field that allows muti-select. The business process fills ok
but not the vendors.

J_Goddard via AccessMonster.com said:
Hi -
The combo box is based on a query from a form that has a combo box field
that allows Mutli-Value selections. ...

What version of Access are you using? In A2003, combo boxes don't have a
multi-select property - list boxes do.

What do you mean when you say "combo box based on a query from a form..."?

John

Thanks for reply but it is not the column settings causing the issue. I
think it has something to do with it being a mult-value select, and coming
from an underlying table.
[quoted text clipped - 12 lines]
uderlying table but then it only returns the one value and not the
mutl-values that have been selected.

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca



.
 

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